List of Bugs Fixed in SQL Server 2014 SP1 CU2 – Part 5

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of Service Pack 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 4775394
FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled SQL service
SQL Server MSDN KB Number 4999045
FIX: An Access Violation occurs when a query uses ISNUMERIC functions in Join conditions in SQL Server 2014 Service Pack 1 SQL performance
SQL Server MSDN KB Number 5181898
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

SQL Server MSDN KB Number 5181900
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service
SQL Server MSDN KB Number 5181902
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service
SQL Server MSDN KB Number 5181933
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014 SQL performance

SQL Server MSDN KB Number 4837970
FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1 SQL service
SQL Server MSDN KB Number 4741544
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014 Management Tools
SQL Server MSDN KB Number 5067465
FIX: TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes SQL security

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings

 

List of Bugs Fixed in SQL Server 2012 SP2 CU7 – Part 2

SQLServerF1

With every release of SQL Server product or subsequent service packs or Cumulative updates, new bugs are encountered or discovered. Below are some of the bugs which were fixed with the release of Service Pack 2 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3068439
FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3068468
FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 SQL service

SQL Server MSDN KB Number 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 SQL performance
SQL Server MSDN KB Number 3069154
FIX: You cannot set a SQL Server 2012 database to single-user mode if the database is read-only SQL service
SQL Server MSDN KB Number 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service

SQL Server MSDN KB Number 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 Analysis Services
SQL Server MSDN KB Number 3074434
FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
SQL Server MSDN KB Number 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

Hope this was helpful.

This is applicable for below versions of SQL Server

SQL Server 2014

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings