List of Bugs Fixed in SQL Server 2012 SP2 CU5 – 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 Cumulative Update 5 (SP 2 CU5) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012 Integration Services

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 3042007
FIX: Access violation may occur when you run a query against the sys.dm_exec_procedure_stats DMV joined on plan_handle SQL service

SQL Server MSDN KB Number 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 3042135
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012 SQL service
SQL Server MSDN KB Number 3044958
FIX: SQL Server 2012 shuts down unexpectedly when you run DBCC CHECKDB and the rollback recovery on the snapshot fails 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 2012 SP2 CU6 – 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 2 Cumulative Update 6 (SP 2 CU6) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3053960
FIX: A system assertion in longrec.inl:1318 occurs when you rebuild or create an index on a table in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3054180
FIX: Time to create a SQL Server LineString instance may take longer than expected in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3029096
FIX: The changes in Oracle database are not replicated to the SQL Server 2012 database correctly Integration Services
SQL Server MSDN KB Number 3047538
FIX: Result of aggregated values is incorrect when you execute a MDX query in SSAS 2012 Analysis Services

SQL Server MSDN KB Number 3054504
FIX: The bcp utility may crash when you use SQL Server 2012 SQL connectivity
SQL Server MSDN KB Number 3054530
FIX: Corruption occurs on the page of secondary replica when you change the secondary replica to unreadable SQL service
SQL Server MSDN KB Number 3043889
FIX: The chart in SSRS 2012 report is not updated correctly when you update the parameter in the URL of the report Reporting Services

SQL Server MSDN KB Number 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 report when the data source is SAP NetWeaver BI type Reporting Services
SQL Server MSDN KB Number 3051145
FIX: SQL Server may shut down when you use Service Broker in SQL Server 2012 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 SP1 CU1 – Part 8

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 3064784
FIX: Access violation occurs when you query against a table that contains column store indexes in SQL Server 2014 SQL Service
SQL Server MSDN KB Number 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
SQL Server MSDN KB Number 2995211
FIX: Incorrect error when you set rotation of chart series label greater than 90 or less than -90 in an SSRS 2012 or 2014 report Reporting Services
SQL Server MSDN KB Number 2997020

FIX: “An item with the same key has already been added” error when you review a report in SSRS 2012 or 2014 Reporting Services
SQL Server MSDN KB Number 3000494
The slides of a PowerPoint file that is exported from a PowerView report show blank when you open it in slider show mode Reporting Services
SQL Server MSDN KB Number 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS in SharePoint integrated mode Reporting Services

SQL Server MSDN KB Number 3019110
FIX: “Duplicate names are not allowed” error when you add multiple filters to the Power View report in SharePoint 2013 Reporting Services
SQL Server MSDN KB Number 3028226
FIX: Error occurs when you try to change the parameters with default values in a report in SSRS 2012 or SSRS 2014 Reporting Services
SQL Server MSDN KB Number 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014 Reporting Services
SQL Server MSDN KB Number 3042544
FIX: Incorrect choice of a nested loops join strategy causes poor query performance in SQL Server 2014 SQL performance

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 4

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 3053664
FIX: Improved memory management for columnstore indexes to deliver better query performance in SQL Server 2014 SQL service
MSDN Support KB Article 3041476
FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 SQL service
MSDN Support KB Article 3045410
FIX: A query that uses the DECRYPTBYKEY function takes longer to be completed in SQL Server 2014 SQL security
MSDN Support KB Article 3048752
FIX: A SELECT query run as a parallel batch-mode scan may cause a deadlock situation in SQL Server 2014 SQL service

MSDN Support KB Article 3041967
FIX: “Unable to retrieve data for this section of the report” error when you request the Service Broker Statistics report in SQL Server 2014 Management Tools
MSDN Support KB Article 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 Integration Services
MSDN Support KB Article 3055799
FIX: “Cannot bulk load” error when you run a query that contains INSERT statements when trace flags 4199 and 610 are enabled on a server that is running SQL Server 2014 SQL performance
MSDN Support KB Article 3052404
FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 SQL connectivity

MSDN Support KB Article 3052244
FIX: Incorrect result when the “must be unique” action is evaluated for an attribute by using SQL Server 2014 Master Data Services MDS
MSDN Support KB Article 3051798
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
MSDN Support KB Article 3051663
FIX: “8156: A database error has occurred” when you run a business rule in SQL Server 2014 Master Data Services MDS
MSDN Support KB Article 3048856
FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014 SQL service
MSDN Support KB Article 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server PowerPivot for SharePoint 2013 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 CU7 – 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 Cumulative update package (CU) 7 for Microsoft SQL Server 2014.

MSDN Support KB Article 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS data mining models Analysis Services
MSDN Support KB Article 3044160
FIX: Performance counters under “ReportServer:Service” object show zero in SSRS 2014 Reporting Services
MSDN Support KB Article 3042370
An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014 SQL service

MSDN Support KB Article 3042135
FIX: Access violation and “No exceptions should be raised by this code” error occur when you use SQL Server 2012 or SQL Server 2014 SQL service
MSDN Support KB Article 3042077
FIX: MDX query returns incorrect results when you run it with subselect after an UPDATE CUBE statement in SSAS 2012 or SSAS 2014 Analysis Services
MSDN Support KB Article 3041859
FIX: Performance issue occurs when you use sqlncli11.dll ODBC driver to access SQL Server in an application SQL connectivity

MSDN Support KB Article 3041056
FIX: A tablix data region is rendered as corrupted in SSRS in Cumulative Update 3 for SQL Server 2012 SP2 Reporting Services
MSDN Support KB Article 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012 or SQL Server 2014 Reporting Services
MSDN Support KB Article 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012 or SQL Server 2014 SQL service
MSDN Support KB Article 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012 or SSIS 2012 Integration 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