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
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 transaction