Cumulative update 8 for SQL Server 2014 SP1

Applies to: Microsoft SQL Server 2014 Service Pack 1SQL Server 2014 Business IntelligenceSQL Server 2014 Business Intelligence More

This article describes cumulative update package 8 (build number: 12.0.4468.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.
  • Microsoft recommends 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 number KB article number Description Fix area
7679005 3157575 FIX: Copy Database Wizard fails when a table contains a sparse column set in SQL Server 2012 or 2014 Management Tools
7678984 3160407 FIX: sys.dm_db_index_usage_stats missing information after index rebuild on SQL Server 2012 or 2014 SQL performance
7683678 3179596 "Failed Assertion = 'm_pExclusiveOwner != pWorker'" is continuously logged in the SQL Server 2014 error log SQL service
7990712 3166545 FIX: Truncation errors when you use bcp command to import data from large text files on a Chinese version of Windows SQL connectivity
7731730 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 Integration Services
7678973 3162396 FIX: Shared data sources and stored credentials are removed by the SharePoint daily cleanup jobs in SSRS Reporting Services
7729207 3170051 FIX: SQL Server 2012 failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting High Availability
7953256 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 SQL service
7872840 3178526 An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014 SQL connectivity
7425610 3178107 SQL Server 2014 crashes because of an access violation error that occurs while it reads data from an event file target SQL service
7678989 3149128 Update to change permissions for running sp_readerrorlog and sp_enumerrorlogs in SQL Server SQL security
7942967 3181260 SQL Server Analysis Services crashes when you belong to multiple roles and execute a CREATE SESSION CUBE statement in SQL Server 2014 Analysis Services
7678979 3152965 FIX: Error 1478 when you add a database back to the AlwaysOn availability group in SQL Server High Availability
7678926 3152596 FIX: Unicode characters are displayed as square blocks after you paste them from an SSRS report Reporting Services
7919412 3180263 FIX: It takes a long time to cancel a query in a Tabular instance of SQL Server 2014 Analysis Services Analysis Services
7596513 3164104 Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014 SQL service
7600391 3164404 FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016 Integration Services
7587229 3176440 FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 SQL service
7307997 3153836 Operating system error 32 when you restore a database in SQL Server 2014 SQL service
7832767 3174476 FIX: Deadlock occurs when you acquire a SCH-M lock and ALTER PARTITION in SQL Server 2014 SQL service
7694335 3160874 FIX: Selection change on Excel grouping errors out when the data is from a SQL Server Analysis Services ROLAP partition Analysis Services
7837465 3181444 FIX: Queries always get recompiled on the secondary databases in SQL Server 2014 High Availability
7678912 3152042 FIX: PageRequestManagerServerErrorException error when you use an invalid date parameter in SSRS Reporting Services
5814980 3181526 The calculation of two measure time values in iterations returns a negative value in SQL Server 2014 SQL service
7678993 3155558 FIX: "Cannot alter column" error after a database is restored to SQL Server SQL service
7781240 3177132 FIX: Garbage collection in In-Memory OLTP may cause "non-yielding scheduler" in SQL Server 2014 In-Memory OLTP
7990683 3150432 Performance of Analysis Services in Multidimensional mode degrades over time Analysis Services
7542934 3161403 The file size of the PDF file generated by SQL Server 2014 Reporting Services is larger when compared to the earlier versions of SQL Server Reporting Services
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 2014 SQL service
7700154 3167159 FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan SQL performance
7694328 3155209 FIX: Can't delete a row from a filtered table part of a merge publication in SQL Server 2012, 2014, or 2016 SQL service
7865489 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
7843660 3175883 Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server SQL performance
7678942 3154226 FIX: Memory leak on the AlwaysOn secondary replica when change tracking is enabled in SQL Server SQL service
7990686 3171896 Transaction log backup failure on the secondary replica prevents subsequent backups on Availability Replicas in SQL Server High Availability
7792813 3171681 Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
7907768 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 Reporting Services
7249656 3145492 FIX: XA transactions aren't cleaned when you exit a Java application in an instance of SQL Server SQL service
7811680 3173471 FIX: Error 3456 "Could not redo log record" occurs, causing replicas to be suspended or repeated behavior in SQL Server SQL service
7504584 3165545 FIX: Unable to execute FORMAT function if it is wrapped inside CLR 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:

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 do not have to make any changes to the registry.