Since Service Pack 1
Regardless of your branch or patch level, be sure to check KB #2964518 : Recommended updates and configuration options for SQL Server 2012 / 2014, which is full of useful advice. Please always perform full regression testing before installing any SQL Server update in production. It’s becoming more and more clear that you might find an issue Microsoft missed.
SQL Server 2014 Service Pack 1 was re-released after being pulled on April 15th due to an issue described in this post. The initial build number was 12.0.4050 but that has been updated to 12.0.4100. The official knowledge base article has been moved to KB #3058865,
Service Pack 1 includes a number of enhancements; these were the most interesting to us:
•The behavior of trace flags 1236 (see KB #2926217) and 9024 (see KB #2809338) will now be enabled by default.
•Several fixes for buffer pool extensions, including the ability to use instant file initialization.
•Improvements in columnstore performance and new extended event coverage for columnstore inserts.
SP1 Cumulative Update #1 includes 141 fixes, including all of the fixes from the RTM Cumulative Updates published up to and after SP1 was released (CU #6, CU #7, and CU #8 – One of the more important fixes is one that involves partial (and thus incorrect) results from a clustered columnstore index with a corrupted rowgroup (more gory details in this blog post and KB #3067257).
Recommendation: Install this Cumulative Update.
Service Pack 1 12.0.4100 KB #3058865 2015-05-15 29 (29)
Service Pack 1 (pulled) 12.0.4050 N/A
RTM Branch
If you are on the RTM branch, SQL Server 2014 is now at Cumulative Update #8 (including well over 400 fixes and enhancements). If you are applying Cumulative Updates at all, or want any of the interim fixes, we highly recommend using the latest update
The Build is 12.0.2546. This cumulative update has 38 public hotfixes . This CU may be less attractive now that Microsoft has also released SQL Server 2014 SP1 CU1. I because many people may get onto the SP1 branch, now that the first CU on top of SP1 has been released, and the branches are back in synch.
Build Name
Build #
KB Article
Date
New fixes (public)
Cumulative fixes (public)
RTM Cumulative Update #8 12.0.2546 KB #3067836 2015-06-22 40 (38) 486 (432)
⚠
One of the more important fixes here is one that involves partial (and thus incorrect) results from a clustered columnstore index with a corrupted rowgroup (more gory details in this blog post and KB #3067257).
Recommendation: Install this Cumulative Update.
COD Hotfix for Azure Premium Storage Support 12.0.2506 KB #3063054 2015-05-19 1 (1) 450 (398)
COD Hotfix for intraquery parallel deadlock 12.0.2505 KB #3052167 2015-05-19 1 (1) 449 (397)
COD Hotfixes for SSIS / CCI 12.0.2504 KB #3058512 2015-05-05 2 (2) 448 (396)
⚠
A hotfix has been issued to address two completely different issues: (1) a problem with the Unpivot transformation task in SSIS (for more info, see KB #3058512), and (2) a problem with join performance when using a clustered columnstore index (see KB #2999809 for more details).
Recommendation: Install this hotfix only if you are using SSIS with Unpivot or clustered columnstore indexes.
RTM Cumulative Update #7 12.0.2495 KB #3046038 2015-04-23 47 (41) 446 (394)
COD Hotfix for Parallel Batch-Mode Deadlock 12.0.2488 KB #3048751 2015-04-01 1 (1) 401 (355)
⚠
A hotfix has been issued to address a potential problem where a parallel, batch-mode scan may lead to a deadlock, and the deadlock cannot be automatically resolved. This should only affect customers using Columnstore indexes. The hotfix can be downloaded from KB #3048751. It is included in Cumulative Update #7 (under a slightly different KB article: KB #3048752).
Recommendation: Install the latest cumulative update above, which includes this fix.
COD Hotfix for Availability Groups with CLR UDTs 12.0.2485 KB #3042370 2015-03-16 1 (1) 400 (354)
⚠
A hotfix has been issued to address a problem with CLR UDTs in Availability Group databases. The hotfix can be downloaded from KB #3043788 and is described in KB #3042370.
Recommendation: Install the latest cumulative update above, which includes this fix.
RTM Cumulative Update #6 12.0.2480 KB #3031407 2015-02-16 64 (55) 399 (353)
COD Hotfix for Availability Groups NOT SYNCHRONIZING 12.0.2474 KB #3034679 2015-02-04 1 (1) 338 (301)
⚠
A hotfix has been issued to fix Availability Groups reporting as NOT SYNCHRONIZING, an issue caused by CU #5 below. That issue is documented in KB #3033492 and explained further in this SQL Server blog post.
Recommendation: Install the latest cumulative update above, which includes this fix.
COD Hotfix for SSMS (Azure SQL Database) 12.0.2472 KB #3032087 2015-01-28 1 (1) 337 (300)
COD Hotfix for query compile waits 12.0.2464 KB #3024815 2015-01-05 1 (1) 336 (299)
⚠
A hotfix has been released that helps alleviate RESOURCE_SEMAPHORE_QUERY_COMPILE waits during concurrent compilation of large queries. A trace flag is also required (-T6498).
Recommendation: Install the latest cumulative update above, which includes this fix. The trace flag is required whether you apply the COD hotfix or the Cumulative Update.
RTM Cumulative Update #5 12.0.2456 KB #3011055 2014-12-17 54 (48) 335 (298)
⚠
Cumulative Update #5 has a known issue with Availability Groups reporting as NOT SYNCHRONIZING.
Recommendation: Avoid this update if you use Availability Groups. Apply the latest cumulative update above instead.
COD Hotfix for Availability Groups remote hardening 12.0.2436 KB #3014867 2014-11-27 1 (1) 282 (251)
⚠
A hotfix for an issue involving exception handling for remote hardening issues in Availability Groups was released on November 27, 2014.
Recommendation: Install the latest cumulative update above, which includes this hotfix. Install this specific hotfix only if you are using Availability Groups and your applications use OLEDB or JDBC (ODBC / SNAC are unaffected) and you don’t want any of the additional fixes in more recent CUs.
RTM Cumulative Update #4 12.0.2430 KB #2999197 2014-10-21 66 (54) 281 (250)
RTM Cumulative Update #3 12.0.2402 KB #2984923 2014-08-18 40 (32) 215 (196)
MS14-044 QFE Security Update 12.0.2381 KB #2984340 2014-08-12 1 (1) 175 (164)
⚠
A denial of service / privilege escalation vulnerability was identified and patched August 12, 2014.
It is described in Security Bulletin MS14-044 and KB #2984340.
Recommendation: Install the latest cumulative update above, which includes this QFE update.
RTM Cumulative Update #2 12.0.2370 KB #2967546 2014-06-27 52 (48) 174 (163)
RTM Cumulative Update #1 12.0.2342 KB #2931693 2014-04-21 121 (114) 122 (115)
MS14-044 GDR Security Update 12.0.2254 KB #2984340 2014-08-12 1 (1) 1 (1)
⚠
A denial of service / privilege escalation vulnerability was identified and patched August 12, 2014.
It is described in Security Bulletin MS14-044 and KB #2984340.
Recommendation: Install this GDR update only if you are at a build less than 12.0.2254 and only if you *don’t* want all of the fixes from the latest cumulative update above.
RTM 12.0.2000 2014-04-01 – –
Share this post:
