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

LOGO__SQLServer2012At the outtage of Azure time Microsoft released two packs wit Cumulative Updates. Both for Microsoft SQL Server 2012 but for different versions. In this post I’ll write about update for SQL Server 2012 with Service Pack 1. In this Cumulative Update No 13 /and still counting?/ {build no 11.0.3482.0} Microsoft fixed about ten bugs and here is the list.

VSTS BUG: 2369445 | KB: 2793580
FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server
Management Tools

VSTS BUG: 3074321 | KB: 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012
SQL service

VSTS BUG: 3029598 | KB: 2994082
FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS
Data Quality Services (DQS)

VSTS BUG: 3053494 | KB: 2995352
FIX: "No catalog entry found for partition ID <ID> in database <Database Name>" error when you use SQL Server 2012
SQL service

VSTS BUG: 3127645 | KB: 2997020
FIX: "An item with the same key has already been added" error when you review a report in SSRS 2012
Reporting Services

VSTS BUG: 3047505 | KB: 2998870
FIX: "The record ID is incorrect" error when you use DAX to execute query in a parent/child dimension in SSAS 2012
Analysis Services

VSTS BUG: 3242852 | KB: 3000494
FIX: The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode
Reporting Services

VSTS BUG: 3153124 | KB: 3005300
FIX: High CPU consumption when you use spatial data type and associated methods in SQL Server 2012
SQL service

VSTS BUG: 3158657 | KB: 3008000
FIX: Error when you use Microsoft Office 15.0 Access Database Engine OLE DB Provider as data source in SSMS 2012
Integration Services

VSTS BUG: 3443831 | KB: 3013551
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update
SQL service

 

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 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Reporting Services
  • 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 13

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:

  1. Install the service pack on the passive node.
  2. 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. And here is the full list af all packages:

>>2012_SP1_DAC_CU13_3002044_11_0_3482_x64
>>2012_SP1_RSShrPnt_CU13_3002044_11_0_3482_x64
>>SQLServer2012_SP1_CU13_3002044_11_0_3482_x64
>>2012_SP1_PPExcel_CU13_3002044_11_0_3482_x64
>>2012_SP1_PPExcel_CU13_3002044_11_0_3482_x86
>>2012_SP1_DAC_CU13_3002044_11_0_3482_x86
>>SQLServer2012_SP1_CU13_3002044_11_0_3482_x86

Enjoy!

[EN] SQL Server 2008 R2 SP2 Cumulative Update 13 isavailable!

NOTE:
This is the final Cumulative Update for SQL Server 2008 R2 Service Pack 2.  SQL Server 2008 R2 SP2 exits mainstream support on July 8, 2014.

The sentence above is most important part in this post. In Last Cumulative Update No 13 (build number: 10.50.4319.0) for SQL Server 2008 R2 SP2 Microsoft fixed fifteen bugs:

 

VSTS BUG: 1918779 | 2922526
FIX: Missing rows on subscriber when you drop and re-add article from another publication or add subscription
SQL service

VSTS BUG: 2463716 | 2926217
FIX: Performance problems occur when database lock activity increases in SQL Server
SQL service

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

VSTS BUG: 2371475 | 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
SQL performance

VSTS BUG: 2525246 | 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: 2272416 | 2957174
FIX: Cannot create compressed nonclustered index on a table that has a clustered index with two or more bit columns
SQL service

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

VSTS BUG: 2447011 | 2963658
FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL Server
SQL service

VSTS BUG: 2442037 | 2963668
FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions
SQL service

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

VSTS BUG: 2462604 | 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: 2451659 | 2971611
FIX: Memory leak occurs during Process Update on a dimension in SSAS 2008 R2
Analysis Services

VSTS BUG: 2626083 | 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server 2008 R2
SQL service

VSTS BUG: 2691569 | 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS 2008 R2
Analysis Services

VSTS BUG: 2624484 | 2977312
FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) in SQL Server 2008 R2
SQL service

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

  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Analysis Services
  • Microsoft SQL Server 2008 R2 Integration 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 13 

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, 32-bit and Itanium) . This release is prepared as multilingual package. And here is the full list af all packages:

>> 2008R2_SP2_CU13_2967540_10_50_4319_IA64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_IA64
>> 2008R2_SP2_MDS_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_x64
>> SQLServer2008R2_SP2_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_RSShrPnt_CU13_2967540_10_50_4319_x64
>> 2008R2_SP2_SNAC_CU13_2967540_10_50_4319_x86
>> SQLServer2008R2_SP2_CU13_2967540_10_50_4319_x86

Enjoy for Last Time!

[EN] SQL Server 2008 SP3 Cumulative Update 13 is available

LOGO__SQLServer2008R2v2Microsoft has published new package of updates for SQL Server 2008  with Service Pack 3. In this Cumulative Update No 13 (Build number: 10.00.5846.0) has fixed two requested bugs:

VSTS BUG: 1375267 | 2812884
FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 1445038 | 2878968
FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server 2008

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

  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web

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 13

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) . This release is prepared as multilingual package. And here is the full list af all packages:

  • SQL Server 2008 | x86 | SQLServer2008_SP3_CU13_2880350_10_00_5846_x86
  • SQL Server 2008 | x64 | SQLServer2008_SP3_CU13_2880350_10_00_5846_x64
  • SQL Server 2008 | ia64 | SQLServer2008_SP3_CU13_2880350_10_00_5846_IA64

Enjoy!