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