Cumulative update package 5 for SQL Server 2014

If you plan to deploy this cumulative update on an AlwaysOn configuration, you must read the following Knowledge Base article before you do this:

Summary

This article describes cumulative update package 5 (build number: 12.0.2456.0) for Microsoft SQL Server 2014. This update contains hotfixes for issues that were fixed after the release of SQL Server 2014.

How to obtain this cumulative update package

Click "Hotfix Download Available" at the top of this Knowledge Base article. If the "Hotfix Request" page does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Hotfixes that are included in this cumulative update package

VSTS bug numberKB article numberDescriptionFix area
35607263009974FIX: Slow AG synchronization when disks have different sector sizes for primary and secondary replica log files in SQL Server SQL service
25154442970136FIX: Cannot remove backup file after you restore the database from Windows Azure Blob storage service in SQL Server 2014 SQL service
37206642981424FIX: Exception when you select more than one hierarchy from parent/child dimension in SSAS 2012 or in SSAS 2014 Analysis Services
32605922986423FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed size SQL service
32606062992069FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 or SSAS 2014 processing Analysis Services
37206702995622FIX: "Specified cast is not valid" when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014 Integration Services
37206712996729FIX: "Non-yielding Scheduler" condition occurs when you run a complex query in SQL Server 2012 or SQL Server 2014 SQL performance
37206722997392FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 or 2014 SQL service
37206352998870FIX: "The record ID is incorrect" error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014 Analysis Services
37206803002071FIX: "System objects not be updated" when you use AlwaysOn Availability Groups in SQL Server 2012 or SQL Server 2014 High Availability
37206823002883FIX: Error occurs when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012 or SQL Server 2014 SQL service
37206833004355FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012 or SQL Server 2014 SQL service
34277183004548FIX: Add Azure Replica wizard cannot enumerate Azure Virtual Network in SQL Server 2014 High Availability
37206473005300FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012 or SQL Server 2014 SQL service
37206853006648FIX: Data corruption in a target table when you use a SQL Server destination in SSIS 2012 or SSIS 2014 SQL service
35607273007050FIX: RTDATA_LIST waits when you run natively stored procedures that encounter expected failures in SQL Server 2014 In-Memory OLTP
37206493008000FIX: Error when you use Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012 or SSMS 2014 Integration Services
37206953009576FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files SQL service
37206963009883FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012 or 2014 SQL performance
37206813011807FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012 or in SQL Server 2014 SQL service
33432253012182FIX: Log_Send_Rate column cannot reflect the rate accurately in SQL Server 2012 or in SQL Server 2014 SQL service
3720668 3013553FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014 SQL service
35566323013861FIX: Upgrade wizard appears again when you reopen the SSIS 2014 solution with upgraded SSIS packages Integration Services
35489103014156An update is available that enables "Edit Top 200 Rows" option for tables and views of SQL Azure database SQL service
3548883 3014164FIX: Cannot use new service tiers Basic, Standard and Premium when you deploy to Windows Azure SQL Database in SSMS 2014 SQL service
35489223014166An update is available that enables "Select Top 1000 Rows" option for tables and views of SQL Azure database SQL service
35579083014193FIX: The view indexes are not visible in the Object Explorer in SSMS 2014 Management Tools
35650983014359FIX: Out-of-range error occurs when you use SQL Server Managed Backup to Windows Azure SQL service
34934733014469FIX: Performance of loading medium-sized to large-sized sized entities and models is poor when you use MDS Add-in for Excel Data Quality Services (DQS)
34246853014825FIX: "No exceptions should be raised by this code" error when you run parallel query in SQL Server 2014 SQL performance
37090353014867FIX: "Remote hardening failure" exception cannot be caught and a potential data loss when you use SQL Server 2014 High Availability
34468463016334FIX: Error when you upgrade a SQL Server 2012 SP2 instance with MDS to SQL Server 2014 DQS
34285683016518FIX: "You do not have permission…" error when you run a report that connects to a .BISM file in PowerPivot gallery Analysis Services
33064063017266FIX: "Requested value ReFS was not found" error when you install SQL Server 2014 on a local drive that is ReFS formatted Setup & Install
35278863020112FIX: Non-yielding error occurs when you execute DML statements in SQL Server 2014 SQL service
35510493020113FIX: Error 35377 occurs when you try to access clustered columnstore indexes in SQL Server 2014 SQL service
36546163020116FIX: "Non-yielding scheduler" error and AlwaysOn Availability Group transitions to RESOLVING state not Failover High Availability
3548637Federations feature will be discontinued with Web and Business service tiers. The Federations related Transact-SQL code examples in SSMS are updated with comments on being discontinued.SQL service
3548892The Property Page shortcut menu item for databases (right-click on a database node and select Properties) on Azure databases is enabled.SQL service
3548904Table Designer is now be used when creating tables on the latest version of Azure SQL Database.SQL service
3548910The Edit Top N rows shortcut menu option is enabled (right-click on Table and select Edit Top N Rows) for opening the Visual Database Tools with N rows populated.SQL service
3548922The Select Top N rows shortcut menu option (right-click a table or a view and select Select Top N Rows) is enabled for generating a script that will select the top N rows from a table or a view.SQL service
3548929The Property shortcut menu option for tables (right-click Table node and select Properties) on Azure databases is enabled.SQL service
3708148The following nodes to Object Explorer for features are added in the latest version of Azure SQL Database:
  • Storage (under Database node)
  • Assemblies (Database node -> Programmability)
  • Rules (Database node -> Programmability)
  • Defaults (Database node -> Programmability)
  • Plan Guides (Database node -> Programmability)
  • Sequences (Database node -> Programmability)
  • Aggregate Functions (Database node -> Functions)
  • Application Roles (Database node -> Security -> Roles)
  • User-defined Object Types (CLR Types) (Database node -> Programmability -> Types)
  • XML Schema Collections (Database node -> Programmability -> Types)
SQL service
3708389The Column and Index subfolders under the Table and View nodes are added.SQL service
3708718The Modify and Execute Stored Procedure shortcut menu options (right-click a stored procedure) when it is connected to the latest version of Azure SQL Database are enabled.SQL service
3708719The Modify shortcut menu option for Functions (right-click a function) when connected to the latest version of Azure SQL Database is enabled.SQL service
3750221Both the Federation and Management nodes from Object Explorer when connected to the latest version of Azure SQL Database are removed. When they are connected to an Azure v. Current server only the management node is removed (Federations are still valid on Azure v.Current).SQL service
3782631The Memory Optimization Advisor shortcut menu option for tables on all Azure databases is removed.SQL service

Notes for this update

Cumulative update

  • We recommend that you test hotfixes before you deploy them in a production environment.
  • We recommend that you apply the most recent update release .
    • This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.
    • The most recent update release contains all the hotfixes and all the updates that were included with the previous SQL Server 2014 update release.
  • We recommend that you upgrade your SQL Server installation to the next SQL Server 2014 service pack .

Hybrid environments deployment

Before you deploy the hotfixes to a hybrid environment (such as AlwaysOn, replication, cluster, mirroring, and cluster), we recommend that you refer to the following articles:
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.

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.
Cumulative update package file information
Atribuudid

Artikli ID: 3011055 – viimati läbi vaadatud: 7. mai 2015 – redaktsioon: 1

Tagasiside