[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!

[EN] SQL Server 2012 SP1 Cumulative Update 11 is available!

LOGO__SQLServer2012SP1Microsoft released in this week two collections of packaged updates for SQL Server product. In this Cumulative Update No 11 for SQL Server 2012 SP1 (Build number: 11.0.3449.0) producer resolved and fixed thirty two bugs. Here is the list:

 

VSTS BUG: 2556590 | 2936984
FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server
SQL service

VSTS BUG: 2525247 | 2952260
FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server
SQL service

VSTS BUG: 2363899 | 2962767
FIX: "Cannot insert duplicate key" error occurs in Spool operation when you update a table in SQL Server 2012
SQL performance

VSTS BUG: 2365851 | 2963137
FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012
Analysis Services

VSTS BUG: 2556601 | 2963408
FIX: Error 5180 occurs when you query BLOB column data in SQL Server
SQL service

VSTS BUG: 2415767 | 2965069
FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012
SQL performance

VSTS BUG: 2442076 | 2965654
FIX: SSRS 2012 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTS BUG: 2437139 | 2965758
FIX: Memory leak occurs when you start and stop an XEvent session repeatedly in SQL Server 2012
SQL service

VSTS BUG: 2442014 | 2965922
FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013
BI Azure

VSTS BUG: 2403797 | 2967103
FIX: Service broker stops working when you unregister and remove a session in SQL Server
SQL service

VSTS BUG: 2525259 | 2967240
FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server
SQL service

VSTS BUG: 2468660 | 2967594
FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server 2012
SQL service

VSTS BUG: 2515401 | 2968909
FIX: Access violation when you query sys.extended_properties table in SQL Server 2012
SQL service

VSTS BUG: 2515449 | 2968914
FIX: Undetected deadlock occurs when you use a sequence object in SQL Server 2012
SQL service

VSTS BUG: 2681957 | 2969896
FIX: Data corruption occurs in clustered index when you run online index rebuild in SQL Server 2012 or SQL Server 2014
SQL performance

VSTS BUG: 2551031 | 2970421
FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored database
High Availability

VSTS BUG: 2598016 | 2972411
FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012
Reporting Services

VSTS BUG: 2425939 | 2972463
FIX: Report cache is not cleaned up after the cache expiration when you use SSRS 2012 in SharePoint integrated mode
Reporting Services

VSTS BUG: 2610505 | 2972996
FIX: Error when you execute a Transact-SQL query that contains a long case statement in SQL Server 2012
SQL service

VSTS BUG: 2521049 | 2973561
FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012
SQL service

VSTS BUG: 2624969 | 2973921
FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS 2012 on SharePoint website
Reporting Services

VSTS BUG: 2445517 | 2974948
FIX: SQL Server resource goes offline when you change password for service account in SQL Server 2012
Management Tools

VSTS BUG: 2425013 | 2975322
FIX: The blank value does not equal to the NULL value in a business rules in MDS of SQL Server 2012
Data Quality Services (DQS)

VSTS BUG: 2415102 | 2975385
FIX: User obtains incorrect data when two users in the same security role run the same client report in SSAS 2012
Analysis Services

VSTS BUG: 2778334 | 2975402
FIX: Log Reader Agent crashes during initialization when you use transactional replication in SQL Server 2012
SQL service

VSTS BUG: 2679072 | 2975498
FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook use certain Korean characters as file name
Reporting Services

VSTS BUG: 2522972 | 2976953
FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012
Analysis Services

VSTS BUG: 2689849 | 2976966
FIX: Cannot install the Windows Forms application that has ReportViewer control
Reporting Services

VSTS BUG: 2403004 | 2977271
FIX: Poor performance when you create spatial index on Point data in SQL Server 2012
SQL service

VSTS BUG: 2777901 | 2979121
FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012
SQL service

VSTS BUG: 2735399 | 2979304
FIX: Error when you run RBS Maintainer in SQL Server 2012
SQL service

VSTS BUG: 2718528 | 2980395
FIX: A sever error occurs when you run a query that uses a hash join parallel execution plan in SQL Server 2012
SQL performance

 

This update could be applied to Microsoft SQL Server 2012 Service Pack 1, when used with:

  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Business Intelligence

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 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. And here is the full list af all packages:

>> 2012_SP1_RBS_CU11_2975396_11_0_3449_x64
>> 2012_SP1_RSShrPnt_CU11_2975396_11_0_3449_x64
>> 2012_SP1_DAC_CU11_2975396_11_0_3449_x64
>> SQLServer2012_SP1_CU11_2975396_11_0_3449_x64
>> 2012_SP1_PPExcel_CU11_2975396_11_0_3449_x64
>> 2012_SP1_RBS_CU11_2975396_11_0_3449_x86
>> 2012_SP1_DAC_CU11_2975396_11_0_3449_x86
>> 2012_SP1_PPExcel_CU11_2975396_11_0_3449_x86
>> SQLServer2012_SP1_CU11_2975396_11_0_3449_x86

Enjoy!

[EN] SQL Server 2008 R2 SP2 Cumulative Update 11 is available

LOGO__SQLServer2008R2SP2Just only one updates package for SQL Server has been released in February. This Cumulative Update no 11 {build number: 10.50.4302.0} is for Microsoft SQL Server 2008 R2 with Service Pack 2. Microsoft resolved twelve errors. Here is the list of fixed bugs :

VSTS BUG: 1790001 | 2829845
FIX: "The provided statistics stream is corrupt" when you run the "UPDATE STATISTICS" statement against a table in SQL Server 2008 R2 or SQL Server 2012
SQL performance

VSTS BUG: 1635573 |2902151
FIX: Change Tracking incorrect current versions in database snapshots in SQL Server 2008 R2
SQL service

VSTS BUG: 1765040 |2912049
FIX: Memory leak occurs when an application that uses SQL Server Native Client tries to connect and close the connection to a SQL Server 2008 R2 instance
SQL connectivity

VSTS BUG: 1993304 |2919611
FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3 or SQL Server 2008 R2 SP2
Setup & Install

VSTS BUG: 1915818 |2920987
FIX: Poor performance when many table-valued parameters are used in SQL Server 2008 R2
SQL service

VSTS BUG: 1993313 |2921630
FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS 2008 or SSAS 2008 R2
Analysis Services

VSTS BUG: 1806945 |2922799
FIX: Unexpected exception is thrown when you convert writeback partition in SSAS 2008 R2
Analysis Services

VSTS BUG: 1993310 |2923837
FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server 2008 or SQL Server 2008 R2
SQL service

VSTS BUG: 1917681 |2924996
FIX: Issues when you export a report to PDF with Unicode fonts in SQL Server 2008 R2
Reporting Services

VSTS BUG: 1972242 |2926699
FIX: Operating system version information that is returned from SQL Server 2008 R2 is incorrect in Windows 8.1
SQL service

VSTS BUG: 2004937 |2928669
FIX: The reports generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards
Reporting Services

VSTS BUG: 1814380 |2929464
FIX: SELECT queries deadlock when ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are enabled in SQL Server 2008 R2
SQL service

 

I f You ever read my posts about cumulative updates, you can see something special: the third, grey line. From this info release Microsoft make “public” one more part of this update -  Fix Area. That’s great, hope it helps all of SQL Folks with implementation of CU.

This update could be applied for: Microsoft SQL Server 2008 R2 Service Pack 2, when used with:

  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 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 want to go directly to download section jump to Request Hotfix Download Site where You can choose version (for all platforms: 64-bit and ia64 and for 32-bit) . This release is prepared as multilingual package. And here is the full list af all packages:

>> x86 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_x86
>> x64 | 2008R2_SP2_RSShrPnt_CU11_2926028_10_50_4302_x64
>> x64 | 2008R2_SP2_MDS_CU11_2926028_10_50_4302_x64
>> x64 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_x64
>> ia64 | SQLServer2008R2_SP2_CU11_2926028_10_50_4302_IA64

Enjoy!