As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 2 Cumulative Update 2!
Service Pack 2 CU#2 can be applied to any of the following Microsoft SQL Server 2012 editions, providing Sp2 has already been installed:
- Microsoft SQL Server 2012 Enterprise
- Microsoft SQL Server 2012 Developer
- Microsoft SQL Server 2012 Standard
- Microsoft SQL Server 2012 Business Intelligence
- Microsoft SQL Server 2012 Web
- Microsoft SQL Server 2012 Express
The build number of the cumulative update package is 11.0.5548.0 So you must be running SQL Server 2012 SP2 (11.0.5058.0). If you have installed CU1 then your build number will be 11.0.5532.0.
You may have to restart the computer after you apply this cumulative update package.
There are over 50 fixes, the highlights for me being:
2987812 FIX: No information about extensive lock conflicts in the SSAS msmdsrv.log file – this is really helpful when troubleshooting!
2986627 FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server 2012
2992069 FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 processing
2980395 FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server 2012 – this one is a biggie for me as I;ve just finished writing a report that gets the size of each run by partition… and it took a lot of effort.
2993483 FIX: SSAS 2012 processing fails when you perform a Process Full operation on many partitions in a transactionFollow @rPh0enix