Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

March 2009 - Posts

Useful links for upgrading to SQL Server 2008
There is plenty of material available to help you upgrade to SQL Server 2008. This blog is intended as a short list for the most useful guidance that I have found. And you may have different experiences upgrading from SQL Server 2000 and SQL Server 2005 Read More...
Posted: Friday, March 27, 2009 12:37 PM by kevincox | 1 Comments
Filed under: ,
Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008
Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server 2005 instance and then reattaching them to a completely new SQL Server 2008 instance. If you choose this upgrade strategy, you should be aware that you Read More...
Posted: Friday, March 20, 2009 1:06 PM by tkejser | 2 Comments
Filed under: , , , ,
Analysis Services Partition Size
Thomas and I updated the SQL Server 2008 Analysis Services Performance Guide principally to address features available in the latest release. But there was one important change related to partition size driven by changes in hardware. The earlier version Read More...
Posted: Friday, March 13, 2009 11:41 PM by richtk | 1 Comments
SQL Server 2008’s Oracle destination fast load option may fail if certain Oracle system views are missing
Author: Nicholas Dritsas Reviewers: Lubor Kollar, Michael Thomassy, Sanjay Mishra SQL Server 2008’s latest feature pack, that can be found here , contains a new Oracle connector by Attunity that supports Oracle versions 9.2.0.4 and higher. When you use Read More...
Posted: Tuesday, March 03, 2009 12:26 PM by Nicholas Dritsas | 1 Comments
Page view tracker