Cumulative update 10 for SQL Server 2014 SP1

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

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 SP1 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).

Download Download the Microsoft SQL Server 2014 Integration Services Attunity Oracle CDC Designer/Service Feature Pack package now.

Note After future CUs are released for SQL Server 2014 Service Pack 1, 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
88508063184099SQL Server crashes with an access violation when you use the TRY…CATCH construct for bulk copy SQL service
85092673196877FIX: Incremental statistics runs with higher sample rate than regular statistics when statistics are created or updated in SQL Server 2014 SQL performance
88508353198826FIX: Can't cancel queries with SORT conditions on cells or measure values in SQL Server 2012 or 2014 Analysis Services Analysis Services
88888143203693 “A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10 SQL service
79622563030352FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database SQL service
88551193201865FIX: The Target Recovery Time of a database set to a nonzero value causes an assertion and a lease timeout in SQL Server 2014 SQL service
88508603197950FIX: Error when you open Data Alert Manager in SQL Server 2014 Reporting Services in SharePoint integrated mode Reporting Services
88983513208179FIX: MDX query returns errors if the value of MaxRolapOrConditions is greater than 256 in SQL Server 2014 Analysis Services Analysis Services
88603493209442FIX: "No Data Available" in the SQL Server Memory Usage page in the SQL Server 2014 MDM report Management Tools
88459113174370A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
89609413198261FIX: MDS business rule doesn't work if the Code value contains a leading space in SQL Server MDS Add-in for Excel Master Data Services (MDS)
83475143067968FIX: Memory is paged out when columnstore index query consumes lots of memory in SQL Server 2014 SQL service
88508033188454Improvement: Enhance VDI Protocol with VDC_Complete command in SQL Server 2012 or 2014 SQL service
87359533205935FIX: Error 2809 when you execute a stored procedure that takes a table-valued parameter from RPC calls in SQL Server 2014 SQL performance
88507973180980Can't export a report as an Excel workbook when the "Interpret HTML Tags as Styles" option is selected Reporting Services
88507843188670FIX: Error when you select a KPI in a Power View report that consumes a BISM connection in a PowerPivot Gallery Analysis Services
88508133005011Unexpected growth of tempdb data files when using SQL Server Service Broker SQL service
88508323198827FIX: KPIs return a non-translated caption when an MDSCHEMA_MEASURES request is issued and the restrictions request hidden members Analysis Services
89616343196012FIX: Incorrect full-text keys are recorded for the rows that aren't indexed correctly by a full-text index in SQL Server 2012 or 2014 SQL service
88507653183686FIX: MDX LastChild function returns incorrect result after ProcessUpdate a dimension in SSAS 2012 or 2014 Analysis Services
85374833208244FIX: Access Violation when you execute queries on a readable secondary replica of a SQL Server 2014 AlwaysOn Availability Group SQL performance
88508193197631FIX: TDE encrypted Databases go in suspect state during the recovery phase when you restart SQL Server 2012 or 2014 SQL security
88508283194365FIX: Rebuilding a nonclustered index to add columns by using CREATE INDEX with DROP_EXISTING=ON and ONLINE=ON causes blocking SQL performance
89609383177238FIX: No automatic failover after database mirroring stops unexpectedly in SQL Server 2012 or 2014 High Availability
87698553201416FIX: Out-of-memory errors when you execute DBCC CHECKDB on database that contains columnstore indexes in SQL Server 2014 SQL service
86500733208245FIX: Incorrect query result when you use varchar(max) variable in the search condition in SQL Server 2014 SQL performance
89609473108537FIX: DBCC CHECKFILEGROUP reports false inconsistency error 5283 on a database that contains a partitioned table in SQL Server SQL service

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 SP1.

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
Properties

Article ID: 3204399 - Last Review: Dec 28, 2016 - Revision: 1

Feedback