[EN] SQL Server 2014 RTM Cumulative Update #8 is available!

LOGO__SQLServer2014On June 22nd (about week ago) Microsoft released two packages of updates. First package is the Cumulative Update No 8 {bulid no 12.0.2546.0} for Microsoft SQL Server 2012 SP2 and Microsoft fixed about forty bugs. Released list of bugs are below:

VSTS BUG: 4523243 | 3067826
An “Access Violation” occurs when you connect to an instance of SQL Server 2014
SQL service

VSTS BUG: 4778150 | 3067257
FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014
SQL service

VSTS BUG: 4745322 | 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4544422 | 3029096
FIX: The changes in Oracle databases are not replicated to SQL Server 2012 or SQL Server 2014 databases correctly
Integration Services

VSTS BUG: 4638931 | 3058512
FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014
Integration Services

VSTS BUG: 4719045 | 3064784
FIX: Access violation occurs when you query against a table that contains column store indexes in SQL Server 2014
SQL service

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

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

VSTS BUG: 4520890 | 3067896
Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014
SQL performance

VSTS BUG: 4715603 | 3070139
FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014
SQL service

VSTS BUG: 4516100 | 3069488
“Non-yielding Scheduler” error occurs and SQL Server stops responding when a database has columnstore indexes on a Microsoft SQL Server 2014 instance
SQL service

VSTS BUG: 4745318 | 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012
SQL connectivity

VSTS BUG: 4745324 | 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 or SSRS 2014 report when the data source is SAP NetWeaver BI type
Reporting Services

VSTS BUG: 4745309 | 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server
SQL security

VSTS BUG: 4745305 | 3043889
FIX: The chart in SSRS 2012 or SSRS 2014 report is not updated correctly when you update the parameter in the URL of the report
Reporting Services

VSTS BUG: 4744173 | 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4336261 | 3036201
FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 or SQL Server 2014 MDS
Master Data Services(MDS)

VSTS BUG: 4638932 | 2999809
FIX: Poor performance when a query contains table joins in SQL Server 2014
Management Tools

VSTS BUG: 4838266 | 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014
SQL service

VSTS BUG: 4320465 | 3048734
FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE
SQL service

VSTS BUG: 4319316 | 3048627
FIX: “Cannot access the specified path or file on the server” when you use CSV in SSMS to back up or restore database
Management Tools

VSTS BUG: 4794520 | 3067968
FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014
SQL service

VSTS BUG: 4465182 | 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

VSTS BUG: 4745307 | 3051993
FIX: The value of NUMBER type is truncated when you select data from an Oracle-linked server by using OLE DB provider
SQL service

VSTS BUG: 4488005 | 3066682
FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014
MDS

VSTS BUG: 4745314 | 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages
Integration Services

VSTS BUG: 4745709 | 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012
Integration Services

VSTS BUG: 4745297 | 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time
Analysis Services

VSTS BUG: 4745299 | 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services
Analysis Services

VSTS BUG: 4729309 | 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014
SQL performance

VSTS BUG: 4745312 | 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2012 or SQL Server 2014
SQL service

VSTS BUG: 4632737 | 3061685
FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014
SQL performance

VSTS BUG: 4729310 | 3063054
Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures
SQL service

VSTS BUG: 4745330 | 3011867
SQL Server in-place upgrade fails if the there’s no JOBS folder
Setup & Install

VSTS BUG: 4745711 | 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry
SQL service

VSTS BUG: 4728820 | 3067659
FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks
SQL service

VSTS BUG: 4633760 | 3053752
FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source
Analysis Services

VSTS BUG: 4507041 | 3055646
FIX: Error 35377 when you run a parallel query that contains MERGE statements in SQL Server 2014
SQL service

 

Newest part of updates is published list detailed publishing time and name of all necessary files in the package. The English version of this package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

x86-based versions

  • SQL Server 2014 Business Intelligence Development Studio
  • SQL Server 2014 Analysis Services
  • SQL Server 2014 Database Services Common Core
  • SQL Server 2014 Data Quality Client
  • SQL Server 2014 Data Quality
  • SQL Server 2014 sql_dreplay_client
  • SQL Server 2014 sql_dreplay_controller
  • SQL Server 2014 Database Services Core Instance
  • SQL Server 2014 Database Services Core Shared
  • SQL Server 2014 Integration Services
  • SQL Server 2014 Reporting Services
  • SQL Server 2014 Management Studio
  • SQL Server 2014 Tools and Workstation Components

x64-based versions

  • SQL Server 2014 Business Intelligence Development Studio
  • SQL Server 2014 Analysis Services
  • SQL Server 2014 Database Services Common Core
  • SQL Server 2014 Data Quality Client
  • SQL Server 2014 Data Quality
  • SQL Server 2014 sql_dreplay_client
  • SQL Server 2014 sql_dreplay_controller
  • SQL Server 2014 Database Services Core Instance
  • SQL Server 2014 Database Services Core Shared
  • SQL Server 2014 Integration Services
  • SQL Server 2014 Reporting Services
  • SQL Server 2014 Management Studio
  • SQL Server 2014 Tools and Workstation Components

 

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

  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Standard
  • Microsoft SQL Server 2014 Express
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Web
  • SQL Server 2014 Reporting Services
  • Microsoft SQL Server 2014 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 8

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_RTM_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleDes_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleSer_CU8_3067836_12_0_2546_x64
    2014_RTM_AOrcleDes_CU8_3067836_12_0_2546_x86
    SQLServer2014_RTM_CU8_3067836_12_0_2546_x86
    2014_RTM_AOrcleSer_CU8_3067836_12_0_2546_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!