[EN] SQL Server 2012 SP2 Cumulative Update #2 is available!

LOGO__SQLServer2012SP2Two packs of this month’s updated for Microsoft SQL Server. In this post I’m writing about updates for SQL Server 2012 again. But this Cumulative Updates No 2 (build number 11.0.5548.0) is for SQL Server 2012 with SP2. Microsoft resolved almost FIFTY bugs. Here is the list:

VSTS BUG:  2921035 | KB: 2924996
FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTS BUG:  2525248 | KB: 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:  2985224 | KB: 2958054
FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL Server
SQL service

VSTS BUG:  2906079 | KB: 2962767
FIX: "Cannot insert duplicate key" error occurs when you update a table by using a bitmap index that contains a partition key in SQL Server 2012
SQL performance

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

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

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

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

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

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

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

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

VSTS BUG:  2782750 | KB: 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:  2906106 | KB: 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:  2906108 | KB: 2968909
FIX: Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014
SQL service

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

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

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

VSTS BUG:  2906096 | KB: 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:  2906120 | KB: 2972996
FIX: Error when you execute a Transact-SQL query that contains a long case statement in SQL Server 2012
SQL service

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

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

VSTS BUG:  2906094 | KB: 2975322
FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014
Data Quality Services (DQS)

VSTS BUG:  2906090 | KB: 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:  2906125 | KB: 2975498
FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file name
Reporting Services

VSTS BUG:  2906114 | KB: 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: 2906129 | KB: 2976966
FIX: Cannot install the Windows Forms application that has ReportViewer control
Reporting Services

VSTS BUG: 2906086 | KB: 2977271
FIX: Performance improvement for SQL Server Spatial data access in SQL Server 2012
SQL service

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

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

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

VSTS BUG:  2906132 | KB: 2980395
FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server 2012
SQL performance

VSTS BUG:  2821553 | KB: 2984249
FIX: Null fields are returned when the dataset in SSRS retrieves a stored procedure with required parameters
Reporting Services

VSTS BUG:  3038775 | KB: 2986423
FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed size
SQL service

VSTS BUG:  2890365 | KB: 2986627
FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server 2012
SQL performance

VSTS BUG:  2902203 | KB: 2987610
FIX: Error when you back up a database that has case-sensitive collation by using VSS in SQL Server 2012 SP2
High Availability

VSTS BUG:  2794982 | KB: 2987809
FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11
Reporting Services

VSTS BUG:  2878593 | KB: 2987812
FIX: No information about extensive lock conflicts in the SSAS msmdsrv.log file
Analysis Services

VSTS BUG:  2878600 | KB: 2988166
FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL Server 2012
Management Tools

VSTS BUG:  2718715 | KB: 2989590
FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS 2012
Analysis Services

VSTS BUG:  2719620 | KB: 2989704
FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL Server
SQL service

VSTS BUG:  2933143 | KB: 2989810
FIX: Error when you use bcp_init to do BCP and use local temp table as input parameter in SQL Server Native Client 11.0
SQL service

VSTS BUG:  2887381 | KB: 2991526
FIX: SSIS XML Source task fails to load the data from URI in SQL Server 2012
Integration Services

VSTS BUG:  2808659 | KB: 2991528
FIX: SSIS package execution fails when it uses DT_TEXT data type after you apply SQL Server 2012 SP2
Integration Services

VSTS BUG:  2738813 | KB: 2992069
FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 processing 
Analysis Services

VSTS BUG:  2895444 | KB: 2992414
FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS 2012
Integration Services

VSTS BUG:  2980111 | KB: 2993262
FIX: Some rows are missing in the result when you run query to select data from Oracle linked server by using merge join
SQL performance

VSTS BUG:  2949206 | KB: 2993483
FIX: SSAS 2012 processing fails when you perform a Process Full operation on many partitions in a transaction
Analysis Services

VSTS BUG:  3000520 | KB: 2993529
FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 MDS 
DQS

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

  • Microsoft SQL Server 2012 Analysis Services
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 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 2

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:

>> SQLServer2012_SP2_CU2_2983175_11_0_5548_x64
>> SQLServer2012_SP2_CU2_2983175_11_0_5548_x86

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!