Archive

Archive for September, 2008

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".
 
 
 
Advertisements
Categories: Patches

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

Categories: Patches