List of Bugs Fixed in SQL Server 2014 SP1 CU2 – 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 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 5181914
FIX: You cannot set a SQL Server 2012 or 2014 database to single-user mode if the database is read-only SQL service
SQL Server MSDN KB Number 5181908
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
SQL Server MSDN KB Number 4772921
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools

SQL Server MSDN KB Number 5181952
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 or 2014 SQL service
SQL Server MSDN KB Number 5196810
FIX: “Requested value was not found” error when you deploy a SQL Server 2014 database to Windows Azure Management Tools
SQL Server MSDN KB Number 5036505
FIX: Can’t view the properties of a contained database in Object Explorer in SQL Server 2014 SP1 Management Tools

SQL Server MSDN KB Number 4921466
FIX: Error 1635 occurs when you use Product Update to install SQL Server 2014 SP1 and SQL Server 2014 SP1 CU1 Setup & Install
SQL Server MSDN KB Number 4776005
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
SQL Server MSDN KB Number 4745317
FIX: Result of aggregated values is incorrect when you execute an MDX query in SSAS 2012 or SSAS 2014 Analysis Services
SQL Server MSDN KB Number 4745296
FIX: Poor performance when you run an MDX query that contains a sub-select of different granularities in SSAS 2012 Analysis Services

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 2014 SP1 CU1 – Part 1

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 1 (SP 1 CU1) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 3041056
FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2 Reporting Services
SQL Server MSDN KB Number 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application SQL connectivity
SQL Server MSDN KB Number 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools

SQL Server MSDN KB Number 3035077
FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking Management Tools
SQL Server MSDN KB Number 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012 or SSRS 2014 Reporting Services
SQL Server MSDN KB Number 3008135
FIX: Abbreviations for million, billion, and others are translated incorrectly in Swedish or Italian Power View report SQL service

SQL Server MSDN KB Number 3000562
FIX: ImageConsolidation device information setting does not work when it is specified in the RSReportServer.config file Reporting Services
SQL Server MSDN KB Number 3053664
FIX: Improved memory management for columnstore indexes to deliver better query performance in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3053040
FIX: Hidden MDS data entries are deleted unexpectedly when you use the Master Data Services add-in for Microsoft Excel in SQL Server 2014 Master Data Services (MDS)
SQL Server MSDN KB Number 3048752
FIX: A SELECT query that’s run as a parallel batch-mode scan triggers a deadlock in SQL Server 2014 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

 

List of Bugs Fixed in SQL Server 2014 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 Cumulative update package (CU) 7 for Microsoft SQL Server 2014.

MSDN Support KB Article 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 or 2014 MDS Master Data Services (MDS)
MSDN Support KB Article 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools
MSDN Support KB Article 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS Reporting Services

MSDN Support KB Article 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS report to Reporting Services Report Manager Reporting Services
MSDN Support KB Article 3037624
FIX: Complex parallel query does not respond in SQL Server 2012 or SQL Server 2014 SQL performance
MSDN Support KB Article 3046893
FIX: Inconsistent data when you add a date before March 1, 1900 in the MDS add-in for Excel in SQL Server 2014 MDS

MSDN Support KB Article 3053040
FIX: Hidden MDS data entries are deleted unexpectedly when you use the Master Data Services Add-in for Microsoft Excel in SQL Server 2014 MDS
MSDN Support KB Article 3023620
FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013 Analysis Services
MSDN Support KB Article 3020750
FIX: Error or blank page when you click the workbook link under “Data Refresh – Recent Activity” Analysis Services
MSDN Support KB Article 3025968
FIX: SSRS pages contain unlabeled check boxes in the detailed view Reporting Services

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 2014 CU6 – 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 Cumulative update package (CU) 6 for Microsoft SQL Server 2014.

MSDN Support KB Article 3030619
FIX: Incorrect data returned when you use DATE data type as a qualifier in a query in SQL Server 2014 SQL service
MSDN Support KB Article 3032067
FIX: Access denied when a newly added user browses to an MDS website in SQL Server 2014 MDS
MSDN Support KB Article 3032068
FIX: No MDSTrace.log file is generated after you enable tracing in the MDS 2014 web.config file MDS
MSDN Support KB Article 3032087
FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014 Management Tools

MSDN Support KB Article 3034297
FIX: Cannot close the connections made by sqlagent.exe when SQL Server and SQL Server Agent run for several days Management Tools
MSDN Support KB Article 3034615
FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014 SQL service
MSDN Support KB Article 3034679
FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING High Availability
MSDN Support KB Article 3035071
FIX: Error when you run a query that contains “Use database_name” or “Execute Stored_Procedure_name” command Management Tools

MSDN Support KB Article 3035077
FIX: Cannot enable the change tracking in Azure SQL Database V12 that supports change tracking Management Tools
MSDN Support KB Article 3035165
FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014 SQL service
MSDN Support KB Article 3036328
FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014 SQL service
MSDN Support KB Article 3036330
FIX: Cannot use SQL Server 2014 SQL Profiler to connect to an instance of SQL Server 2005 Management Tools

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