A subtle redirection
Microsoft has released a hotfix (12.0.2504) which includes two fixes. KB #2999809 : FIX: Poor performance when a query contains table joins in SQL Server 2014 – this actually has to do with segment elimination in clustered columnstore indexes. KB #3058512 : FIX: Unpivot Transformation task changes null to zero […]
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 – […]
Stop me if you've heard this one before. Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services team blog: Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS […]
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. […]
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 […]
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) […]
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 […]
Back in September, I blogged about the availability of SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4. I made it clear that there would be no cumulative updates after those service packs, and while there still hasn't been any such release, Microsoft this week *kind […]
A hotfix has been released for an issue that causes Availability Groups to show as NOT SYNCHRONIZING. The original issue is described in KB #3033492 and in this SQL Server Release Services Team blog post. The issue was introduced through Cumulative Update #5 for SQL Server 2014 RTM, and through […]
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 […]
Microsoft has released Cumulative Update #5 for SQL Server 2014. KB Article: KB #3011055 56 fixes total (47 fixes listed publicly at time of publication). Build number is 12.0.2456 Relevant for @@VERSION 12.0.2000 through 12.0.2455
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) […]