Cumulative Updates – SQL Server 2012 SP2 CU2

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 transaction

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s