AKAWN® LIMITED

SQL Server specialists

SQL Server 2014

The below table reflects the builds released for SQL Server 2014 as well as key comments that relate to the build where appropriate.

 

The current recommended Build is 12.0.5546.0 (SP2 with SP2_CU5).
 

Patch Build Type* Released Comment
SP2_CU5 12.0.5546.0 CU 2017 Apr Contains SQL Server 2014 or 2016 crashes on the execution of the DBCC CLONEDATABASE command fix.
SP1_CU12 12.0.4511.0 CU 2017 Apr
SP2_CU4 12.0.5540.0 CU 2017 Feb Contains 20+ fixes.

Can’t set a database to partial containment if SQL Server change tracking was ever enabled on that database fix.

Access Violation when you execute queries on a readable secondary replica of a SQL Server 2014 AlwaysOn Availability Group fix.

Includes MS15-058 update.

An Always On secondary replica goes into a disconnecting state fix.

Cannot connect to a named instance after failover on a mirror server fix.

Cannot execute the DBCC CLONEDATABASE command on an instance of SQL Server 2014 or 2016 after an in-place upgrade fix.

Incremental statistics runs with higher sample rate than regular statistics when statistics are created or updated fix.

Incorrect query result when you use varchar(max) variable in the search condition fix.

“Invoke-sqlcmd” cmdlet executes a query statement multiple times if an error occurs fix.

Memory leak when you run a query that you don’t have sufficient permissions for fix.

SQL Server is stopped when you install patches on an instance of SQL Server 2014 that contains many databases fix.
SP1_CU11 12.0.4502.0 CU 2017 Feb Contains 10+ fixes.

An Always On secondary replica goes into a disconnecting state fix.

Cannot connect to a named instance after failover on a mirror server fix.

AFTER DELETE triggers occur in the wrong order in the ON DELETE CASCADE action chain fix.

Assert memory dump on a mirror server fix.

Includes MS15-058 update.

On failover, the new secondary replica stops accepting transaction log records until the instance is restarted fix.
SP2_CU3 12.0.5538.0 CU 2016 Dec Contains 30+ fixes.

Deadlock causes deferred transaction on the secondary replica in an Always On environment fix.

A memory leak occurs when you use Azure Storage fix.

Unexpected growth of tempdb data files when using SQL Server Service Broker fix.

TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server fix.

On failover, the new secondary replica stops accepting transaction log records until the instance is restarted in SQL Server fix.

An assertion occurs when you restore a clone database that has Query Store enabled fix.

DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server fix.

Availability databases in incorrect initializing/synchronizing state after failover fix.

Sqlps utility fails to run when the “Turn on Script Execution” policy is set to “Allow all scripts” and the syspolicy_purge_history job fails fix.

Introduces DBCC CLONEDATABASE.

Updates to DBCC CLONEDATABASE functionality.

You cannot select any replica when you fail over from an availability group that’s in the resolving state fix.

Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes fix.

Queries that run against secondary databases always get recompiled in SQL Server fix.

Distribution Agent fails for a SQL Server 2014 publisher and a SQL Server 2012 subscriber in Transactional Replication fix.

The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout fix.

Memory leak when you query sys.dm_sql_referenced_entities view fix.

No automatic failover after database mirroring stops unexpectedly in SQL Server fix.

FileTable directory stops responding when you create multiple files concurrently fix.

Error 21050 when you remove a table that is not part of a publication fix.
SP1_CU10 12.0.4491.0 CU 2016 Dec Contains 20+ fixes.

“A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10 with Secure Boot enabled fix.

A memory leak occurs when you use Azure Storage fix.

Unexpected growth of tempdb data files when using SQL Server Service Broker fix.

Access Violation when you execute queries on a readable secondary replica of a SQL Server 2014 AlwaysOn Availability Group fix.

TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server fix.

No automatic failover after database mirroring stops unexpectedly in SQL Server fix.

Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes fix.

Incorrect query result when you use varchar(max) variable in the search condition fix.

DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server fix.
MS16-136 12.0.5532.0 CU 2016 Nov For use with CU/QFE path builds 12.0.5000.0 to 12.0.5522.0
MS16-136 12.0.5203.0 GDR 2016 Nov For use with GDR path build 12.0.5000.0
MS16-136 12.0.4487.0 CU 2016 Nov For use with CU/QFE path builds 12.0.4100.1 to 12.0.4474.0
MS16-136 12.0.4232.0 GDR 2016 Nov For use with GDR path build 12.0.4100.1
SP2_CU2 12.0.5522.0 QFE 2016 Oct Contains 10+ fixes.

SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy fix.

Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 fix.

SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement fix.

Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage fix.

Cannot uninstall service packs after a cumulative update is installed fix.

Canceling a query takes a long time in a Tabular instance of Analysis Services fix.

A memory leak occurs when you use Azure Storage fix.

db_name() and db_id() functions fail to trigger permissions check fix.
SP1_CU9 12.0.4474.0 QFE 2016 Oct Contains 10+ fixes.

FileTable directory stops responding when you create multiple files concurrently fix.

Cannot uninstall service packs after a cumulative update is installed fix.
SP2_CU1 12.0.5511.0 QFE 2016 Aug Contains 30+ fixes.

PowerShell script jobs trigger DCOM errors after you install Azure PowerShell fix.

Failover cluster diagnostic log doesn’t accurately reflect the failure_condition_level setting fix.

Memory leak on the AlwaysOn secondary replica when change tracking is enabled fix.

“The log backup chain is broken” error when the log backup process fails fix.

Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas fix.

Service Broker UCS task leaks memory fix.

Sqlps utility fails to run when the “Turn on Script Execution” policy is set to “Allow all scripts” fix.

Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS fix.

Can’t create a database backup by executing smart_admin.sp_backup_on_demand on a non-preferred backup replica fix.
SP1_CU8 12.0.4468.0 QFE 2016 Aug Contains 30+ fixes.

Copy Database Wizard fails when a table contains a sparse column fix.

sys.dm_db_index_usage_stats missing information after index rebuild fix.

Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs fix.

Failover cluster diagnostic log doesn’t accurately reflect the failure_condition_level setting fix.

A memory leak occurs when you use Azure Storage fix.

An error occurs when you use ODBC driver to retrieve sql_variant data fix.

SQL Server crashes because of an access violation error that occurs while it reads data from an event file target fix.

SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement fix.

Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage fix.

Operating system error 32 when you restore a database rom a striped backup set that contains FILESTREAM data fix.

Queries that run against secondary databases always get recompiled fix.

Garbage collection in In-Memory OLTP may cause “non-yielding scheduler” fix.

Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation fix.

Decrease in performance and “non-yielding scheduler” errors caused by unnecessary spinlocks fix.

Memory leak on the AlwaysOn secondary replica when change tracking is enabled fix.

Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas fix.

Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 fix.

The “MSRS 2014 Windows Service: Active Session” counter incorrectly displays a very high value fix.

XA transactions aren’t cleaned when you exit a Java application fix.
SP2 12.0.5000.0 GDR 2016 Jul Contains 30+ enhancements/fixes.

Release information.

New management command DBCC CLONEDATABASE and new database property DATABASEPROPERTYEX(‘dbname’, ‘IsClone’).

New stored procedure sp_flush_CT_internal_table_on_demand for the manual cleanup of the change tracking side table.

New AlwaysOn extended events and performance counters added.

Adds DROP TABLE DDL support for articles that are included in transactional replication.

Adds Dynamic Management Function (DMF) sys.dm_db_incremental_stats_properties element to let you access properties of incremental statistics.

sys.dm_db_index_operational_stats fix.

Informational messages for tempdb configuration added.

Information about whether Database Instant File Initalization is enabled added.

sys.dm_os_memory_nodes fix.

UTF-8 encoding support for the BCP utility and BULK INSERT added.

Improvements for SQL Server AlwaysOn Lease Timeout supportability added.

dm_exec_query_stats has new columns added.

New extended events query_memory_grant_usage and hash_spill_details added, plus event fields to added to some existing extended events.

Automatic Soft-NUMA when using trace flag 8079 added.

SOS_RWLock improvement added.
SP1_CU7 12.0.4459.0 QFE 2016 Jun Contains 30+ fixes.

High CPU usage on SQL queries after you install SQL Server 2014 Service Pack 1 fix.

Access violation occurs when you use the TDE and BPE features fix.

SQLDiag utility fix.

Incorrect page numbers are displayed when you export a SSRS 2012 or 2014 report to PDF or TIFF format fix.

PowerShell script jobs trigger DCOM errors after you install Azure PowerShell fix.

Copy Database Wizard fix for sparse columns.

SQL Server 2014 doesn’t start after you configure the tempdb database to use a very small log file fix.

DBCC CHECKTABLE clustered columnstore index rebuild fix.

Retention policy does not work when you use SQL Server Managed Backup to Windows Azure fix.

Service Broker Usage Control Service (UCS) task leaks memory fix.

SSIS WMI Event Watcher task stops processing files fix.

SQL Server 2014 crashes when you execute a query that contains a NONEXISTENT query hint on an In-Memory OLTP database fix.

Non-yielding Scheduler fix.

smart_admin.sp_backup_on_demand stored procedure fix.

SQL Server Managed Backup to Windows Azure tries to back up database snapshots fix.

Managed Backup Retention-based cleanup task fails because of a query time-out fix.
RTM_CU14 12.0.2569.0 QFE 2016 Jun Final CU for RTM.

Contains 20 fixes.

Incorrect page numbers are displayed when you export a SSRS 2012 or 2014 report to PDF or TIFF format fix.

Permissions for running sp_readerrorlog and sp_enumerrorlogs change.

sys.dm_db_index_usage_stats missing information after index rebuild fix.

Memory corruption occurs and causes an access violation fix.

Memory leak on the AlwaysOn secondary replica when change tracking is enabled fix.

Copy Database Wizard fix for sparse columns.

SQLDiag utility fix.
SP1_CU6 12.0.4457.0 QFE 2016 May Refreshed build

SP1 CU6 fix.
SP1_CU6 12.0.4449.0 QFE 2016 Apr Deprecated build – do not use.

Contains 20+ fixes.

Unique GUID column fix and similar scalar user-defined function fix.

Versioning cleanup task on an AlwaysOn secondary replica fix.

Upgraded variable-length column fix.

xp_logininfo fix.

Transactional Replication fix.

CHANGETABLE function fix.

Assertion failure on AlwaysOn Availability Groups secondary replica fix.

SELECT INTO statement together with TABLOCKX hint or the TABLOCK and UPDLOCK hints fix. Another SELECT INTO fix.

Partition schemes, functions, full-text fix.

FILESTREAM-enabled database files on a dynamic disk fix.

SQL Server Managed Backup fix.

Stored procedure that uses a cursor on a table variable fix.

Crash due to cancelling a backup task fix.

Reduce the In-Memory checkpoint files to 1 MB fix. Requires trace flag 9929.

Running multiple UPDATE STATISTICS for different statistics on a single table concurrently enhancement fix. Requires trace flag 7471.

Service master key (SMK) fix.

AlwaysOn Availability Groups columnstore index corruption fix.

INSTEAD OF trigger uses a different collation than the contained database fix.

SQL Server Analysis Services (SSAS) backup failure fix.

BULK INSERT task to copy data from a source file that exists in a FileTable fix.

FileTables in an AlwaysOn availability group become unavailable after failover fix.

Memory corruption fix.

Table-Valued User-Defined function referred to by a synonym fix.
RTM_CU13 12.0.2568.0 QFE 2016 Apr Contains 20+ fixes.

Majority of the fixes are the same as those in SP1 CU6. Additional fixes include:

Crash when you execute a query that contains a NONEXISTENT query hint on an In-Memory OLTP database fix.

SSIS WMI Event Watcher task stops processing files fix.
SP1_CU5 12.0.4439.1 QFE 2016 Feb Contains 20 fixes.

Certificate back up fix.

ODBC Driver 11 fix.

-k startup parameter to control the rate that work files can spill to tempdb.

Replication fix.

AlwaysOn Availability Groups columnstore index corruption fix.

Assertion failure fix1 and fix2.

Database Engine Tuning Advisor fix.

SSRS PDF export fix.

Partitioned table with a columnstore index fix.

Parallel query that contains a many-to-many merge join fix.

Log shipping restore job with Buffer Pool Extension (BPE) fix.

Tempdb usage fix.
RTM_CU12 12.0.2564.0 QFE 2016 Feb Contains 7 fixes.

SSRS fix1 and fix2.

Back up the certificate fix.

AlwaysOn Availability Groups columnstore index corruption fix and assertion failure fix.

Tempdb usage fix.
SP1_CU4 12.0.4436.0 QFE 2015 Dec Contains 30+ fixes.

SQL Server 2012 Native Client (SNAC) fixes are no longer included in CUs and can be down loaded from here.

DBCC CHECKDB fix1, fix2 and fix3.

sys.database_permissions memory leak fix.

Compressed data fix.

Virtual address space (VAS) fix.

Connection pooling fix.

SQLTables function and sp_tables stored procedure don’t require SELECT permission.

Database mirroring fix.

WITH CHECK OPTION fix.

Service Broker enhancement and fix.


DBCC CHECKFILEGROUP fix.

Remote query fix.

Buffer Pool Extension (BPE) with log shipping fix.

XEvent Linq reader fix.

Trace flag 2430 fix.

GetPathLocator fix.

Extended events fix.

Transparent data encryption (TDE) with the buffer pool extension (BPE) fix.

Transparent Data Encryption (TDE) fix.

sqlcmd fix.

Transactional replication fix.

Service Broker fix.

Parallel query on a columnstore index fix.
RTM_CU11 12.0.2560.0 QFE 2015 Dec Contains 10+ fixes.

Change Data Capture fix.

Database mirroring fix.

Transparent Data Encryption (TDE) fix.

sqlcmd fix.

Service Broker enhancement and fix.

XEvent Linq reader fix.

ODBC Driver11 fix.

Compressed data fix.

Parallel query fix.

Connection pooling fix.

SQLTables function and sp_tables stored procedure don’t require SELECT permission.

Merge Replication fix.

Partitioned table with column store index fix.
SP1_CU3 12.0.4427.24 QFE 2015 Oct Contains 30+ fixes.

In-memory OLTP database backup fix.

Resource Governor CAP_CPU_PERCENT fix.

Query compile performance fix.

SSAS crash fix.

100% CPU usage when an in-memory OLTP database is in a recovery state fix.

DBCC CHECKFILEGROUP fix.

DBCC CHECKDB reporting behavior for invalid filegroups fix.

DBCC CHECKDB performance fix.

ALTER DATABASE SET HADR OFF fix.

AlwaysOn log file growth issue fix.

Backup failures after enabling change tracking fix.

Memory-optimized filegroup transaction log offline checkpoint fix.

sqlcmd fix.

Master Data Services (MDS) case-sensitive does not work fix.
RTM_CU10 12.0.2556.4 QFE 2015 Oct Contains 20+ fixes.

AlwaysOn log file growth issue fix.

Virtual address space (VAS) fix.

SQL Server 2014 remote query crash fix.

Viewing the property of a contained database fix.

Resource Governor CAP_CPU_PERCENT fix.

TDE certificate creation fails if the serial number is greater than 16 bytes fix.

Backup failures after enabling change tracking fix.

DBCC CHECKDB performance fix.
SP1_CU2 12.0.4422.0 QFE 2015 Aug Contains 40+ fixes.

Missing resource database after you install updates or service packs for instances fix.

Reset the max_worker_threads column value for a SQL Server Agent subsystem fix.

AlwaysOn Availability Groups maintenance plan backups fix.

CHANGETABLE() function fix.

Full-text query with parallel execution plan fix.

CMEMTHREAD waits fix.

Database single user mode fix.

SQL Server 2014 SQL Profiler connecting to SQL Server 2005 fix.

Deployment of a SQL Server 2014 database to Windows Azure fix.

Cannot view the properties of a contained database in Object Explorer fix.

Restore Log with Standby Mode on an Advanced Format disk fix. Also requires trace flag 3075.

Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS fix.

SQL Server 2014 Analysis Services crash fix1, fix2 and fix3.

SQL Server 2014 Analysis Services memory consumption fix.

AlwaysOn availability groups failover fix.

microsoft.sqlserver.types.dll fix.

SQL Server Reporting Services Report Builder startup fix.

Bulk copy program (bcp) utility fix.

AlwaysOn NOT SYNCHRONIZING fix.

Common criteria compliance causes an access violation and unexpected SQL Server shutdown fix.

ISDATE or ISNUMERIC functions fix.

sp_estimate_data_compression_savings fix.

Hash or merge join hints fix. Also requires trace flag 4199.

Maintenance Plan performs offline index rebuild for large object table fix.

TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes fix.
RTM_CU9 12.0.2553.0 QFE 2015 Aug Contains 30 fixes.

AlwaysOn NOT SYNCHRONIZING fix.

Bulk copy program (bcp) utility fix.

Virtual address space (vas) fix. Also requires trace flag 8075.

sp_estimate_data_compression_savings fix.

microsoft.sqlserver.types.dll fix.

Hash or merge join hints fix. Also requires trace flag 4199.

AlwaysOn Availability Groups maintenance plan backups fix.

Columnstore index corruption during rebuild when using parallelism fix.

AlwaysOn availability groups failover fix.

Database single user mode fix.

CMEMTHREAD waits fix.

Full-text query with parallel execution plan fix.

Missing resource database after you install updates or service packs for instances fix.

sqlcmd utility fix.

CHANGETABLE() function fix.

Deployment of a SQL Server 2014 database to Windows Azure fix.
MS15-058 12.0.2548.0 QFE 2015 Jul Use with RTM QFE builds between and including 12.00.2342 to 12.0.2546.0.
MS15-058 12.0.2269.0 GDR 2015 Jul Use with RTM GDR builds between and including 12.00.2000 to 12.0.2254.0.
SP1_CU1 12.0.4416.0 QFE 2015 Jun Contains 120+ fixes.

Report Designer and Report Builder fix.

sqlncli11.dll ODBC driver fix.

Allow Microsoft SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 fix.

Enable Azure SQL Database V12 change tracking using Microsoft SQL Server 2014 Management Studio fix and another fix.

Too many columnstore fixes to list.

Data loss when using Microsoft Azure Storage to store SQL Server database files over a high-latency network connection fix.

DECRYPTBYKEY function performance fix.

Upgrade a Data Transformation Service (DTS) package using Microsoft SQL Server 2014 Data Tools fix.

AlwaysOn database with common language runtime (CLR) user-defined data type (UDT) crash or error 3961 fix.

Create statistics fix.

Complex parallel query undetected deadlock fix.

Addition of 3 new stored procedures to clean up MDS history.

sys.dm_exec_requests value of statement_start_offset column fix.

Connecting fix.

Indexed view using scalar SUM clause fix.

SSIS package Flat File Source fix.

USERSTORE_SCHEMAMGR memory leak fix.

DBCC CHECKDB and DBCC CHECKTABLE SQL CLR User-Defined type (UDT) performance fix.

SQL Server Analysis Service (SSAS) proactive caching fix.

Introduces trace flag 6498 which lets more than one large query compilation gain access to the big gateway when there is sufficient memory available.

Introduces trace flag 6534 for updating the sorting algorithm to include angular vectorization techniques that significantly improve the LineString performance.

Database with large transaction log file restore in the Microsoft Azure binary large object storage service fix.

Windows Azure Blob storage service backup file removal fix.

SQL Server Analysis Services (SSAS) ProcessData and then ProcessRecalc corruption fix.

SQL Server Analysis Service (SSAS) crash fix.

Transaction isolation level is reset fix.

Allows use of trace flag 174 which lets you increase the bucket count for the SQL Server plan cache.

Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT-BI) version 12.0.2299.1 connectivity fix.

Transport Layer Security (TLS) protocol version 1.2 fix.

Azure SQL V12 Azure Web and Business editions are removed from Microsoft SQL Server Management Studio 2014 fix.

Introduces new IgnoreDimensionSecurityForPC ChildCount property in the SSAS configuration file msmdsrv.ini.

Microsoft SQL Server 2014 nested loops join query performance fix.

DTExec processing Microsoft SQL Server Analysis Services (SSAS) data mining models fix.

Transactional replication fix.

Microsoft SQL Server Analysis Service (SSAS) HardMemoryLimit fix.

Enables Premium Storage support for Data files on Azure Storage and resolves backup failures.

Introduces trace flag 7311 for changing Oracle NUMBER type precision/scale.

Change Data Capture (CDC) Service for Oracle by Attunity fix.

Service Broker fix.
RTM_CU8 12.0.2546.0 QFE 2015 Jun Contains 30+ fixes.

Connecting fix.

Service Broker fix.

Change Data Capture (CDC) Service for Oracle by Attunity fix.

Indexed view using scalar SUM clause fix.

Transport Layer Security (TLS) protocol version 1.2 fix.

Several columnstore fixes.

Introduces trace flag 7311 for changing Oracle NUMBER type precision/scale.

SQL Server Analysis Service (SSAS) crash fix.

Introduces trace flag 6534 for updating the sorting algorithm to include angular vectorization techniques that significantly improve the LineString performance.

Create statistics fix.

Enables Premium Storage support for Data files on Azure Storage and resolves backup failures.

Data loss when using Microsoft Azure Storage to store SQL Server database files over a high-latency network connection fix.
RTM_CU7 12.0.2495.0 QFE 2015 Apr Contains 40+ fixes.

Allows Microsoft SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005.

Performance Monitor ReportServer:Service counters fix.

Deadlock monitor fix.

sqlncli11.dll ODBC driver fix.

SQL Server 2012 SP2 CU3 Report Designer and Report Builder tablix fix.

Improved memory management for columnstore indexes.

Undetected deadlock caused by a SELECT query that generates a parallel batch-mode scan fix.

Trace flags 4199 and 610 fix.

Adds support for Transport Layer Security (TLS) protocol version 1.2 to SQL Server 2014 and to the Microsoft ODBC Driver for SQL Server.
SP_1 12.0.4100.1 GDR 2015 May NOTE: This service pack has originally released in April and was recalled. If you have version 12.0.4050.0 you must uninstall that update before you install this update.

Contains up to and including SQL Server 2014 RTM CU5.

The list of fixes is detailed here.

Three additional columns: KeyAlgorithm, EncryptorThumbprint and EncryptorType have been added to the output of RESTORE HEADERONLY.

.NET Framework 3.5 is now not required when you install SQL Server 2014 Express Edition (with Database Engine only) on Windows 8.

Transaction replication performance issues logging improvements; add verbose message to the stats in history tables and more detailed messages in the agent logs.

Trace flag T9024 is no longer required as SP1 includes this fix by default.

Read committed snapshot isolation parallelism performance fix.

SQL Server Analysis Services logging improvements.

SQL Server crashes when the log file of tempdb database is full fix.

Error 17066 or 17310 during SQL Server startup fix.

Buffer Pool Extension fix1 and fix2.

sp_sequence_get_range duplicate sequence value fix.

AlwaysOn availability groups are reported as NOT SYNCHRONIZING fix.

SQL Server Management Studio can now fully manage Full-Text in SQL Server Express.

New Dynamic Management Function (DMF) sys.dm_fts_index_keywords _position_by_document.
RTM_CU6 12.0.2480.0 QFE 2015 Feb Contains 50+ fixes.

Introduces a new IgnoreDimensionSecurityForPC ChildCount property in the SSAS configuration file msmdsrv.ini.

Introduces a trace flag 6498. This trace flag lets more than one large query compilation gain access to the big gateway when there is sufficient memory available.

Keep index online while reindexing checkbox fix in Maintenance Plan Wizard.

Error 17066 or 17310 during SQL Server startup fix.

Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014 which has a columnstore index fix.

AlwaysOn availability groups are reported as NOT SYNCHRONIZING fix.

Fix for the statement_start_offset column of sys.dm_exec_requests.

Use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 fix.
RTM_CU5 12.0.2456.0 QFE 2014 Dec Contains AlwaysOn Availability Group bug.

Contains 30+ fixes.

We are starting to see more Azure SQL Database friendly options in SQL Server Management Studio.
RTM_CU4 12.0.2430.0 QFE 2014 Oct Contains 50+ fixes.

Introduces trace flag 3448 which assists with a database mirroring manual failover issue.

Introduces trace flag 3861 to allow moving system tables into the primary filegroup.

Introduces trace flag 9348 which uses query optimizer cardinality estimates to decide whether bulk insert should be initiated or not.

sp_send_dbmail stored procedure attachment truncation fix.

Parallelism deadlock fix.

SQL Server 2014 Management Studio maintenance plan designer fix.

Missing rows with merge join from Oracle linked server fix.

Excessive blocking when deleting lots of rows from a very large table with a full-text index fix.
RTM_CU3 12.0.2402.0 QFE 2014 Aug Contains 30+ fixes. Enables SQLDOM to support service_objective.
MS14-044 12.0.2381.0 QFE 2014 Aug Use with RTM QFE path. 32-bit Edition is not affected.
MS14-044 12.0.2254.0 GDR 2014 Aug Use with RTM GDR path. 32-bit Edition is not affected.
RTM_CU2 12.00.2370 QFE 2014 Jun Contains 40+ fixes.
LOB disk space reclaim fix.
Possible data corruption during online index rebuild fix.
Possible metadata corruption during update of index statistics on a partitioned table fix.
RTM_CU1 12.00.2342 QFE 2014 Apr The CU published on 21 Apr 2014 was removed due to an issue when installing the RTM with CU1 slipstream causing the installation to fail with the error message:
An error occurred during the installation of assembly ‘Microsoft.SqlServer.Diagnostics .STrace, fileVersion =”12.0.2000.8″,version=”12.0.0.0000″, culture=”neutral”, publicKeyToken =”89845DCD8080CC91″, processorArchitecture=”MSIL”‘. The signature or catalog could not be verified or is not valid.
RTM 12.00.2000 GDR 2014 Apr Evaluation Edition download EOL** (MS 2019 Jul, ES 2024 Jul)

* Build Types can be either:

SP – Service Pack (This patch is recommended to be applied if it is supported by your application and testing in a non-Production environment is successful.)

GDR – General Distribution Release (Same recommendation as a Service Pack.)

QFE – Quick Fix Engineering (This type of patch should only be applied if it contains a fix to an issue being experienced.)

** EOL – End of Life for Product

SP (Service Pack Support End Date)

MS (Mainstream Support End Date)

ES (Extended Support End Date)