Simon Worth’s SQL Server Weblog

Microsoft has released cumulative update 9 for SQL Server 2008 SP1.  The link to the details page can be found here.  As with most cumulative updates, Microsoft does warn against installing these packages unless you are experiencing specific issues that are addressed in the update.  SP2 will contain all cumulative updates after SP1 – so if you don’t need any of the specific fixes then it is probably best to wait for the next service pack to be released.

A few of the fixes include

• Error message when you run a SQL Server 2005 or SQL Server 2008 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]"
• Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer
• A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008
• A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format
• Blank spaces between some items are generated incorrectly in a SQL Server 2008 report
• "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008
• A query returns inconsistent results before the data cache is warmed up in SSAS 2008

These are just a few of the fixes, visit the website for more information on all issues resolved and to get further details on how to download the updates if required.