[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 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 2014 RTM Cumulative Update 02 is available!

Time for second update packages for SQL Server 2014. In this Cumulative Update No 2 for SQL Server 2014 RTM (build version 12.0.2370.0) Microsoft fixed almost fifty (instead of over one hundred forty updates for CU1) bugs and erors. Here is the list of all:

 

VSTS BUG: 2320904 | 2926223
FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012 or SQL Server 2014
Management Tools

VSTS BUG: 2525263 | 2928300
FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server
SQL performance

VSTS BUG: 2577481 | 2931815
FIX: Loads or queries on CCI tables block one another in SQL Server 2014
SQL service

VSTS BUG: 2525268 | 2932559
FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014
Analysis Services

VSTS BUG: 2357157 | 2933103
FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server
SQL performance

VSTS BUG: 2357159 | 2936154
FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server
Management Tools

VSTS BUG: 2525272 | 2938192
FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014
Integration Services

VSTS BUG: 2357155 | 2938476
FIX: Errors when you use export/import data wizard to move data in SQL Server
Integration Services

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

VSTS BUG: 2356245 | 2950189
FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server
SQL performance

VSTS BUG: 2525282 | 2950209
FIX: Access violation when the start offset is larger than the string length in Substring function in SQL Server
SQL service

VSTS BUG: 2525284 | 2952101
FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server
SQL performance

VSTS BUG: 2356249 | 2953354
FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server
SQL service

VSTS BUG: 2525270 | 2954480
FIX: SSAS instance crashes when you perform writeback action by using the role with cell security defined
Analysis Services

VSTS BUG: 2578298 | 2956619
FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system
Integration Services

VSTS BUG: 2525286 | 2958062
FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2525279 | 2960237
FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server
Data Quality Services (DQS)

VSTS BUG: 2578300 | 2960310
FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server
SQL service

VSTS BUG: 2525301 | 2960735
FIX: Windows Update for SQL Server 2012 or SQL Server 2014 image does not work in Windows Azure Virtual Machine gallery
Setup & Install

VSTS BUG: 2525295 | 2960989
FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package
DQS

VSTS BUG: 2525290 | 2961254
FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2
Analysis Services

VSTS BUG: 2323206 | 2961258
FIX: Cannot access the data in FileTable after you upgrade from SQL Server 2012 SP1 to SQL Server 2014
SQL service

VSTS BUG: 2525299 | 2962650
FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014
Analysis Services

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

VSTS BUG: 2403053 | 2966096
FIX: Access violation when you insert data into a table that has a clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 2452407 | 2967198
FIX: DBCC SHRINKDATABASE or DBCC SHRINKFILE cannot move pages that belong to the nonclustered columnstore index
SQL service

VSTS BUG: 2525261 | 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: 2525266 | 2967634
FIX: SSIS 2012 or SSIS 2014 XML validator only outputs "TRUE" or "FALSE" when you perform XML validation
Integration Services

VSTS BUG: 2593575 | 2967900
FIX: Data models do not load after you run a PowerPivot scheduled data refresh job when you work with SQL Server 2014
Analysis Services

VSTS BUG: 2307220 | 2968023
FIX: Error in checking master database after you bind a memory-optimized database to a resource pool in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2505083 | 2968627
FIX: Dump file and deadlock when you run update and CTAS with limited log space in SQL Server 2014 PDW V2 AU1
SQL service

VSTS BUG: 2505028 | 2968658
FIX: Latch time-out when you insert data into the CCI on an AlwaysOn secondary site in SQL Server 2014
SQL service

VSTS BUG: 2262840 | 2968974
FIX: You cannot create a power view report against a UDM cube in SSAS 2014
Analysis Services

VSTS BUG: 2525689 | 2969419
FIX: Truncated CCI partitioned table runs for a long time in SQL Server 2014
SQL service

VSTS BUG: 2525699 | 2969421
FIX: Poor performance when you bulk insert into partitioned CCI in SQL Server 2014
SQL service

VSTS BUG: 2467130 | 2969741
FIX: Sys.indexes returns incorrect value for indexes in SQL Server 2014
In-Memory OLTP

VSTS BUG: 2516201| 2969781
FIX: Error when you add a custom connection manager in SSIS 2014 Designer
Integration Services

VSTS BUG: 2685532 | 2969896
FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 2515444 | 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure Blob storage service in SQL Server 2014
SQL service

VSTS BUG: 2415675 | 2970137
FIX: Instance ID is different in related system tables after you register a database as a DAC in SQL Server 2014
Management Tools

VSTS BUG: 2551005 | 2970386
FIX: Metadata corruption occurs when you update index statistics with INCREMENTAL=ON in SQL Server 2014
SQL performance

VSTS BUG: 2612142 | 2973444
FIX: "SQL Server performance counters are disabled" when you move the SQL Server resource in SQL Server 2014
Reporting Services

VSTS BUG: 2262877 | 2974373
FIX: Poor performance when you use DAX functions on a String or Boolean column in SSAS 2014
Analysis Services

VSTS BUG: 2370041 | 2974374
FIX: Cloud Adapter crashes when you restore a database on a Windows Azure virtual machine deployed by using a SQL Server 2014 image
Management Tools

VSTS BUG: 2531344 | 2974376
FIX: Error when you execute a stored procedure that inserts records into temp table the second time in SQL Server 2014
SQL service

VSTS BUG: 2505065 | 2974397
FIX: Error when you drop a clustered columnstore index table during recovery in SQL Server 2014
SQL service

VSTS BUG: 2505092 | 2974398
FIX: "Possible termination due to exception during stack unwinding" error during exception handling in SQL Server 2014
SQL service

VSTS BUG: 2361316 | 2962599
FIX: Can now disable checking whether dimension and partition data originate from the same data source when you run a ROLAP query in SQL Server 2014
Analysis Services

 

This update could be applied to :

  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Web
  • Microsoft SQL Server 2014 Business Intelligence
  • 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 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:

>> SQLServer2014_RTM_CU2_2967546_12_0_2370_x64
>> SQLServer2014_RTM_CU2_2967546_12_0_2370_x86

Enjoy!