View Complete Post
i am upgrading 2000 olap cube to 2005. i built an ssas project and deploy to the server.
the 2000 olap cube store it's data in partitions - one for each month.
the face table delete it's data and store data for only the last 13 month so basically most of the data
is store onle in the 2000 cube.
while upgrading the cube and processed it , a lot of information had lost.
i know that i cant restore the fact from the partiotn data but is there a way to copy the partition has is
from olap 2000 to 2005?
We have a Merge Replication system between SQL 2008 R2 Enterprise and Express edition. 2 servers are on the same domain, and everything works fine by sql replication.
When we want to synchronize by web synchronization, we get an error like below
"The merge process detected a mismatch while evaluating the subscriber partition validation expression. The problem can be resolved by
reinitializing the subscription." (we did reinitializing but same error again!)
and also this another error message in same situation
" - The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up.
- The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention
period, or because of one of the replicas being restored to a backup older than retention period, or because of the publisher performing more aggressive cleanup on articles of type download-only and articles with partition_options = 3."
Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.
MSDN Magazine September 2004
I have some logging that has to be done, which are some database update or inserts.
However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.
So I want this code only executed after that the page is complete.
I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.
I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.
Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr