[EN] SQL Server 2014 SP1 Cumulative Update #2 is available!

LOGO__SQLServer2014downloadTwo weeks ago Microsoft released two new packages with cumulative updates. In my secnd post I writing about Cumulative Update No 2 {build 12.0.4422.0} for SQL Server 2014 with Service Pack 1 release. In this package Microsoft fixed almost fifty bugs and here is the list:

VSTSBUG: 4814178 | 3088041
FIX: 401 error occurs when you try to connect to an MDS solution by using MDS Add-in for Excel
MDS

VSTSBUG: 5181962 | 3074535
FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server
SQL service

VSTSBUG: 5181906 | 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem
Management Tools

VSTSBUG: 4812206 | 3082885
FIX: Cannot find file error occurs when you execute a maintenance plan to back up database in SQL Server 2014
SQL service

VSTSBUG: 5181968 | 3075176
FIX: Incorrect results from the CHANGETABLE() function when snapshot isolation is enabled for a SQL Server 2012 or 2014 database
SQL service

VSTSBUG: 5181959 | 2820068
Can’t install SQL Server by using InstallShield or bootstrapping application
Setup & Install

VSTSBUG: 5181957 | 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 or 2014 Master Data Services to start the workflow
Data Quality Services (DQS)

VSTSBUG: 5181924 | 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014
SQL performance

VSTSBUG: 5181916 | 3074425
FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 5181914 | 3069154
FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only
SQL service

VSTSBUG: 5181908 | 3076444
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 or 2014
SQL service

VSTSBUG: 4772921 | 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005
Management Tools

VSTSBUG: 5181952 | 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014
SQL service

VSTSBUG: 5196810 | 3083187
FIX: “Requested value was not found” error when you deploy a SQL Server 2014 database to Windows Azure
Management Tools

VSTSBUG: 5036505 | 3081758
FIX: Can’t view the properties of a contained database in Object Explorer in SQL Server 2014 SP1
Management Tools

VSTSBUG: 4921466 | 3075850
FIX: Error 1635 occurs when you use Product Update to install SQL Server 2014 SP1 and SQL Server 2014 SP1 CU1
Setup & Install

VSTSBUG: 4776005 | 2987585
Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012
SQL service

VSTSBUG: 4745317 | 3047538
FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4745296 | 3033456
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012
Analysis Services

VSTSBUG: 4737005 | 3016384
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4736989 | 3010148
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS
Analysis Services

VSTSBUG: 4736988 | 3006838
FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time
Analysis Services

VSTSBUG: 4584562 | 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension
Analysis Services

VSTSBUG: 5159952 | 3081291
FIX: Increased HADR_SYNC_COMMIT wait types when AlwaysOn Availability Groups contain memory-optimized tables in SQL Server 2014 Service Pack 1
High Availability

VSTSBUG: 5020141 | 3081074
FIX: A stalled dispatcher system dump occurs forcing a failover and service outage on the availability groups in SQL Server 2014 Service Pack 1
High Availability

VSTSBUG: 5181955 | 3068776
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 or 2014
SQL performance

VSTSBUG: 5181937 | 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer
Reporting Services

VSTSBUG: 5181930 | 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014
SQL service

VSTSBUG: 4867179 | 3071617
FIX: “Cannot Start Application” error occurs when you start SQL Server Reporting Services Report Builder in SQL Server 2014 Service Pack 1
Reporting Services

VSTSBUG: 4741577 | 3028216
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4741535 | 3025408
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4737114 | 3029126
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube
Analysis Services

VSTSBUG: 4737059 | 3017544
FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently
Analysis Services

VSTSBUG: 4584553 | 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 or SSAS 2014
Analysis Services

VSTSBUG: 4584517 | 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services
Analysis Services

VSTSBUG: 4744189 | 3054504
FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014
SQL connectivity

VSTSBUG: 4767653 | 3057876
FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status in SQL Server 2014
High Availability

VSTSBUG: 4921039 | 3073294
FIX: “Possible schema corruption. Run DBCC CHECKCATALOG” error occurs when you delete column in SQL Server 2014
SQL service

VSTSBUG: 4775394 | 3067113
FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled
SQL service

VSTSBUG: 4999045 | 3075939
FIX: An Access Violation occurs when a query uses ISNUMERIC functions in Join conditions in SQL Server 2014 Service Pack 1
SQL performance

VSTSBUG: 5181898 | 3030352
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database
SQL service

VSTSBUG: 5181900 | 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications
SQL service

VSTSBUG: 5181902 | 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012
SQL service

VSTSBUG: 5181933 | 3064454
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014
SQL performance

VSTSBUG: 4837970 | 3077726
FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1
SQL service

VSTSBUG: 4741544 | 3027214
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014
Management Tools

VSTSBUG: 5067465 | 3082513
FIX: TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes
SQL security

 

This update could be applied Microsoft SQL Server 2014, when used applies to

  • Microsoft SQL Server 2014 Service Pack 1 ONLY

 

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

    SQLServer2014_SP1_CU2_3075950_12_0_4422_x64
    SQLServer2014_SP1_CU2_3075950_12_0_4422_x86

     

Enjoy!

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