List of Bugs Fixed in SQL Server 2012 SP2 – PART 3

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 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2952444
FIX: Poor performance when you use table variables in SQL Server 2012
SQL Server MSDN KB Number 2936328
FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012
SQL Server MSDN KB Number 2827857
FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

SQL Server MSDN KB Number 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
SQL Server MSDN KB Number 950185
Improved messaging around processing errors and warnings when you work with large HTML reports.
SQL Server MSDN KB Number 950189
Improved messaging around processing errors and warnings when you work with reports with large number of parameters.

SQL Server MSDN KB Number 994470
Incorrect results when you work with block mode unary operators.
SQL Server MSDN KB Number 1041277
DPM’s full backup on the server with AlwaysOn secondary will be converted to copy_only backup.
SQL Server MSDN KB Number 1278767
The value of tabular instance perfmon counters: Memory\VertiPaq KB is always 0.
SQL Server MSDN KB Number 1355346
The end SCOPE statement does not match the opening SCOPE statement.

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *