[EN] SQL Server 2014 RTM Cumulative Update #11 is available!

In December SQL Server Release Services Team released two update packs. Both for SQL Server 2014. Second Cumulative Update no 11 {build no 12.0.2560.0} is for SQL Server 2014 in RTM (Release To Manufacture) version.

This update (VSTS BUG: 5285700 | 321185) introduces a new global property that exposes the latest CU number that is currently installed on the SQL Server. After you install this update, you can obtain the CU number information by executing either of the following queries:

          SELECT @@VERSION
          SELECT SERVERPROPERTY(‘PRODUCTUPDATELEVEL)

Additionally, this update also adds the CU number information to the first line of the SQL Server error log.

In this update packs Microsoft fixed eighteen bugs and below you will find list of fixed errors with KB articles numbers.

VSTS BUG: 6207282 | 3115774
FIX: It takes a long time to install service packs or cumulative updates in SQL Server 2014
SQL service

VSTS BUG: 6225602 | 3120675
FIX: Assertion failure occurs when you run a query in SQL Server 2014
SQL performance

VSTS BUG: 5715113 | 3081150
FIX: Orientation setting is lost when you export a report to a Word document in SSRS 2012 or SSRS 2014
Reporting Services

VSTS BUG: 6279799 | 3103472
FIX: SQL Server service performs more I/O operations on the mirror server than on the principal server
High Availability

VSTS BUG: 6279779 | 3101120
FIX: SQL Server stops responding when you back up the certificate that is used to encrypt the database encryption key in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 5715074 | 3082877
FIX: No error is prompted when connection is ended in sqlcmd
SQL service

VSTS BUG: 6279785 | 2835348
Update improves the Service Broker when you send messages to remote servers in SQL Server 2012 and SQL Server 2014
SQL service

VSTS BUG: 5587447 | 3112710
FIX: Performance is slow when you open and read event files (.xel) by using XEvent Linq reader in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 6279793 | 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 6165695 | 3116718
FIX: Access violation occurs when you use ODBC driver in SQL Server 2014
SQL connectivity

VSTS BUG: 6213785 | 3119197
FIX: Access violation occurs when you update compressed data in SQL Server 2014
SQL service

VSTS BUG: 6286721 | 3120287
FIX: Incorrect result occurs when you run parallel query that contains many-to-many merge join in SQL Server 2014
SQL performance

VSTS BUG: 6279777 | 3097636
FIX: Performance decrease when application with connection pooling frequently connects or disconnects in SQL Server
SQL service

VSTS BUG: 6279789 | 3103644
SQLTables function and sp_tables stored procedure don’t require SELECT permission any longer on user tables and views
SQL security

VSTS BUG: 6293212 | 3094865
FIX: “The process could not initialize ”” error occurs when you use merge publication in SQL Server 2014
SQL service

VSTS BUG: 6189269 | 3121647
FIX: “Non-yielding Scheduler” occurs when you query a partitioned table with column store index in SQL Server 2014
SQL performance

VSTS BUG: 6279795 | 3102243
FIX: The version and version flag properties of subscription view can’t be updated correctly in MDS 2012 or MDS 2014
Master Data Services (MDS)

VSTS BUG: 6279765 | 3097970
FIX: Sp_describe_undeclared_parameters returns incorrect result when the undeclared parameter targets a decimal column
SQL service

This update could be applies to:

  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Web
  • SQL Server 2014 Reporting Services 

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 11

You may have to restart the computer after you apply this cumulative update. If you use any hybrid technology, such a Replication, AlwaysOn, Clustering:  If you do not want to use the rolling update process, follow these steps in order to apply a CU or SP: step1: Install the service pack on the passive node / step2: Install the service pack on the active node (This step requests servicerestart).

If You want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for both platforms: 64-bit and 32-bit) . This release is prepared as multilingual package.

Enjoy!