Cumulative update 2 for SQL Server 2014 SP2

Applies to: Microsoft SQL Server 2014 Service Pack 2SQL Server 2014 DeveloperSQL Server 2014 Enterprise More

This article describes cumulative update package 2 (build number: 12.0.5522.0) for Microsoft SQL Server 2014 Service Pack 2 (SP2). This update contains fixes that were released after the release of SQL Server 2014 SP2.

Cumulative update

Cumulative updates are now available at the Microsoft Download Center.

Only the most recent cumulative update (CU) that was released for SQL Server 2014 SP2 is available at the Download Center.

  • Each new CU contains all the fixes that were included with the previous CU for the installed version/Service Pack of SQL Server.
  • We recommend ongoing, proactive installation of CUs as they become available:

    • SQL Server CUs are certified to the same levels as Service Packs, and should be installed at the same level of confidence.
    • Historical data shows that a significant number of support cases involve an issue that has already been addressed in a released CU.
    • CUs may contain added value over and above hotfixes. This includes supportability, manageability, and reliability updates.

  • Just as for SQL Server service packs, we recommend that you test CUs before you deploy them to production environments.
  • We recommend that you upgrade your SQL Server installation to the latest SQL Server 2014 service pack .

How to obtain this cumulative update package


The following update is available from the Microsoft Download Center:If the download page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

The Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack is a stand-alone package that provides additional value for SQL Server Integration Services (SSIS).Note After future CUs are released for SQL Server 2014 Service Pack 2, this CU can be downloaded from the Microsoft Windows Update Catalog. However, we recommend that you install the latest CU that's available.

Additional hotfixes that are included in this cumulative update package


VSTS bug number KB article number Description Fix area
8147939 3191487 Improved SQL Server stability and concurrent query execution for some columnstore queries in SQL Server 2014 and 2016 SQL service
8055445 3184099 SQL Server 2012 crashes with an access violation when you use the TRY…CATCH construct for bulk copy SQL service
8001813 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server 2012 or 2016 SQL service
8198005 3171681 Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
8343827 3180060 FIX: Queries that use CHANGETABLE use much more CPU after you install SQL Server 2014 SP1 CU6 SQL service
8198037 3181260 SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server 2014 Analysis Services
8197973 3161403 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server Reporting Services
8204790 3195825 FIX: A deadlock occurs when you execute a query plan that has a nested loop join between two hash joins working in the batch mode in SQL Server 2014 SQL performance
8197979 3164104 Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014 SQL service
8197999 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016 Integration Services
8275510 3189033 FIX: Cannot uninstall service packs for SQL Server 2014 after a cumulative update is installed Setup & Install
8198023 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
8198033 3180263 FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 Analysis Services Analysis Services
8198040 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
8292291 3189645 FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139 SQL service
8198029 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Reporting Services
8273664 3194961 db_name() and db_id() functions fail to trigger permissions check in SQL Server SQL security
7636756 3165168 Change Data Capture function fn_cdc_get_net_changes_ incorrectly returns delete and update operation rows for an update operation in SQL Server SQL Engine

Notes for this update


Hybrid environments deployment

When you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, and mirroring), we recommend that you refer to the following articles before you deploy the hotfixes:

Cumulative update package information


Prerequisites

To apply this cumulative update package, you must be running SQL Server 2014 SP2.

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you don't have to make any changes to the registry.