Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have been told that we can greatly reduce our processing times by rebuilding our 2000 cubes in 2008. I was told the difference is substantial (2hrs down to 20mins).

Is this true? If so, why?

share|improve this question
Too many imponderables to give a definitive answer, but SSAS 2005 and later are much, much better products than SSAS 2000. Plus, SQL Server 2000 is deprecated so you really ought to look at migrating off it anyway. – ConcernedOfTunbridgeWells Apr 13 '12 at 9:57
up vote 1 down vote accepted

Performance usually improves from version to version of SQL Server. SQL Server 2000's Analysis Services was nowhere near quick.

As to why - Microsoft doesn't give us the source code so it's a little tough to analyze that. ;-)

Like @ConcernedOfTunbridgeWells pointed out in his comment, though, the real reason you should get off SQL Server 2000 is that it's out of support.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.