Two new CU updates have been released for SQL 2008
- Cumulative Update #3 for SQL Server 2008 SP1 (Build 10.00.2723)
- Cumulative Update #6 for SQL Server 2008 RTM
Things that stand out are:
- [970399] FIX: The MAXDOP option for a running query or the max degree of parallelism option for the sp_configure stored procedure does not work in SQL Server 2008
- [969844] FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 or in SQL Server 2008
- [969997] FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008
- [970507] FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: “Violation of PRIMARY KEY constraint ‘<PrimaryKey>’. Cannot insert duplicate key in object ‘<TableName>’”
- [971064] FIX: Quotation marks are rendered incorrectly when you export a SQL Server 2008 Reporting Services report to a .csv file
Obviously you need to really read to understand if you have seen any of the problems the fixes address to be fully aware – and definitely don’t apply unless you need a fix!
Gareth