Cumulative update 2 for SQL Server 2014 SP2

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.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
81479393191487Improved SQL Server stability and concurrent query execution for some columnstore queries in SQL Server 2014 and 2016 SQL service
80554453184099SQL Server 2012 crashes with an access violation when you use the TRY…CATCH construct for bulk copy SQL service
80018133189229FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server 2012 or 2016 SQL service
81980053171681Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
83438273180060FIX: Queries that use CHANGETABLE use much more CPU after you install SQL Server 2014 SP1 CU6 SQL service
81980373181260SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server 2014 Analysis Services
81979733161403The 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
82047903195825FIX: 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
81979793164104Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014 SQL service
81979993168740An 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
82755103189033FIX: Cannot uninstall service packs for SQL Server 2014 after a cumulative update is installed Setup & Install
81980233025408FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
81980333180263FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 Analysis Services Analysis Services
81980403174370A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
82922913189645FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139 SQL service
81980293176993FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Reporting Services
82736643194961db_name() and db_id() functions fail to trigger permissions check in SQL Server SQL security

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:

Language support
Components updated
Support for this update
How to uninstall this update

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.
Cumulative update package file information
プロパティ

文書番号:3188778 - 最終更新日: 2016/11/29 - リビジョン: 1

フィードバック