SQL Server 2014 Cumulative Update #7 is available!

Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is 12.0.2495  Relevant for @@VERSION 12.0.2000 through 12.0.2494  Note: This cumulative update is only for RTM – […]

On-Demand Hotfix for Parallel Batch-Mode Deadlocks in SQL Server 2014

Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock cannot be resolved automatically. The hotfix can be downloaded from KB #3048751 and will bump SQL Server to 12.0.2488. […]

On-Demand Hotfix for Availability Groups in SQL Server 2014

Last week, Microsoft released an on-demand hotfix for SQL Server 2014, which you shgould consider installing if you are using Availability Groups and any of the relevant databases use CLR user-defined types (UDTs). The symptom is described in KB #3042370, and you should get enough info just from the title […]

March 2015 Cumulative Updates for SQL Server 2012

Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL Server 2012 Service Pack 1 Cumulative Update #15 KB #3038001 Build #11.0.3487 1 fix (1 public) […]

SQL Server 2014 Cumulative Update #6 is available!

Microsoft has released Cumulative Update #6 for SQL Server 2014. This update fixes a few important issues exposed in Cumulative Update #5; see this blog post for some more information about those issues. KB Article: KB #3031047 64 fixes total (55 fixes listed publicly at time of publication)  Build number […]

Out-of-band query compile hotfix for SQL Server 2014

Last week, Microsoft released an out-of-band hotfix to resolve an issue surrounding excessive RESOURCE_SEMAPHORE_QUERY_COMPILE waits. If you are experiencing this issue, or if you are diligent about applying the most recent hotfixes, you should apply this fix. You will need to enable trace flag 6498 in order to benefit from […]

November 2014 Cumulative Updates for SQL Server 2012

Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL Server 2012 Service Pack 1 Cumulative Update #13 KB #3002044 Build #11.0.3482 13 fixes (10 public) […]