THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Damian Widera

SQL Server 2014 Service Pack 2 Cumulative Update #2 Released!

The 2nd cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site.

Good thing is that registration is no longer required to download Cumulative updates.


VSTS bug number KB article number Description Fix area
8147939 3191487 Query performance improvement for some columnstore queries in SQL Server 2014
8055445 3184099 SQL Server 2012 crashes with an access violation when you use the TRY…CATCH construct for bulk copy SQL service
8001813 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server 2012 or 2016 SQL service
8198005 3171681 Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
8343827 3180060 FIX: Queries that use CHANGETABLE use much more CPU after you install SQL Server 2014 SP1 CU6 SQL service
8198037 3181260 SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server 2014 Analysis Services
8197973 3161403 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server Reporting Services
8204790 3195825 FIX: A deadlock occurs when you execute a query plan that has a nested loop join between two hash joins working in the batch mode in SQL Server 2014 SQL performance
8197979 3164104 Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014 SQL service
8197999 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016 Integration Services
8275510 3189033 FIX: Cannot uninstall service packs for SQL Server 2014 after a cumulative update is installed Setup & Install
8198023 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
8198033 3180263 FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 Analysis Services Analysis Services
8198040 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
8292291 3189645 FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139
8198029 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Reporting Services
8273664 3194961 db_name() and db_id() functions fail to trigger permissions check in SQL Server

To learn more visit pages:




Published Wednesday, October 19, 2016 11:16 AM by Damian
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment

Privacy Statement