Cumulative Update Package 2 for SQL Server 2008
Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008.
Earlier posting on Cumulative Update Package 1 for SQL 2008 one of the user asked me how to find out how many update packages were released after SQL Server 2008 RTM is released, the answer is refer to this KBA956909 for more information.
As per the notes on the KBA958156 :
A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package.
If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package
A few hotfixes that were important for me on this CU2 are:
| 958792 |
FIX: You cannot rebuild an index by using the REBUILD argument together with the ALTER TABLE statement or the ALTER INDEX statement if the table uses Sparse Columns as defined in SQL Server Management Studio |
There are many more and for such information refer to the KBA958156 article above, a piece of advice before closing is you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.