SQL Server 2008 MERGE Hotfix

SQL Server 2008 Critical-on-Demand Hotfix 1750

SQL Server 2008 has seen the release of it’s first hotfix. It relates to the usage of the MERGE statement in the case where the target column of the update has a nonclustered unique index.

 

Microsoft "recommend(s) that you apply this hotfix if you use the MERGE statement to update columns that have nonclustered unique indexes that are referenced by foreign key constraints".

 

For more information: http://support.microsoft.com/kb/956718

 

 

SQL Server 2005 Service Pack 2 CU 9

Microsoft Released SQL Server 2005 Service Pack 2 Cumulative Update 9

SQL Server 2005 Service Pack 2 Cumulative Update 9 (CU9) is available from Microsoft Help and Support.

Since SQL Server 2005 Service Pack 2 Microsoft has released 9 Cumulative Updates, fixing over 580 bugs:

 

Cumulative Update	Date	Bugs Fixed
SP2	05-Mar-2007	152
CU1	03-Apr-2007	29
CU2	14-Jun-2007	81
CU3	11-Aug-2007	53
CU4	02-Oct-2007	53
CU5	09-Dec-2007	61
CU6	09-Feb-2008	38
CU7	10-Apr-2008	39
CU8	16-Jun-2008	44
CU9	19-Aug-2008	37

  

The Cumulative Updates reflect Microsoft’s new Incremental Servicing Model for SQL Server, which aims to release the latest updates for SQL Server using a regular schedule (every 8 weeks).

Otherwise, I maintain an Excel 2007 spreadsheet that contains a list of all bug fixes for analysis:

http://cid-a65be80360df3915.skydrive.live.com/embedrowdetail.aspx/Resources/SQLServer2005.CumulativeUpdates.xlsx