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

SQL Server MSDN KB Number 2965922
FIX: Issue when you configure scheduled data refresh for the PowerPivot workbook in SharePoint 2013 BI Azure
SQL Server MSDN KB Number 2967103
FIX: Service broker stops working when you unregister and remove a session in SQL Server SQL service
SQL Server MSDN KB Number 2967240
FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server SQL service
SQL Server MSDN KB Number 2967594
FIX: Fatal exception when you run a query that contains CLR functions against an indexed view in SQL Server 2012 SQL service

SQL Server MSDN KB Number 2968909
FIX: Access violation when you query sys.extended_properties table in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 2968914
FIX: Undetected deadlock occurs when you use a sequence object in SQL Server 2012 SQL service
SQL Server MSDN KB Number 2970421
FIX: The database sticks in role configuration phase when you perform a manual failover of a mirrored database High Availability

SQL Server MSDN KB Number 2972411
FIX: Error when you print, print preview, or export the report to PDF in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 2972463
FIX: Report cache is not cleaned up after the cache expiration when you use SSRS 2012 in SharePoint integrated mode Reporting Services
SQL Server MSDN KB Number 2972996
FIX: Error when you execute a Transact-SQL query that contains a long case statement 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 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 10

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 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server SQL security
SQL Server MSDN KB Number 2619077
FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry SQL service
SQL Server MSDN KB Number 3063054
Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures SQL service

SQL Server MSDN KB Number 3067257
FIX: Partial results in a query of a clustered columnstore index in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3048627
FIX: “Cannot access the specified path or file on the server” when you use CSV in SSMS to back up or restore database Management Tools
SQL Server MSDN KB Number 3058512
FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014 Integration Services

SQL Server MSDN KB Number 3013551
FIX: SQL Server is in script upgrade mode for a long time after you apply a SQL Server hotfix or security update SQL service
SQL Server MSDN KB Number 3038332
FIX: Data Alerts tables are filled up and never clear old data when you use alerts for SSRS 2012 or SSRS 2014 reports Reporting Services
SQL Server MSDN KB Number 3040675
FIX: Data-driven subscription with email notification shows “0 errors” when email delivery fails in SSRS 2012 or SQL Server 2014 Reporting Services
SQL Server MSDN KB Number 3051993
FIX: The value of NUMBER type is truncated when you select data from an Oracle-linked server by using OLE DB provider 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 9

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 3070139
FIX: Error 33294 occurs when you alter column types on a table that has clustered columnstore indexes in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3023629
FIX: High CPU usage after you use DTExec utility to process SSAS data mining models Analysis Services
SQL Server MSDN KB Number 3016165
FIX: Arithmetic overflow error occurs when you add manually initialized subscriptions for publication in SQL Server SQL service

SQL Server MSDN KB Number 3025968
FIX: SSRS pages contain unlabeled check boxes in the detailed view Reporting Services
SQL Server MSDN KB Number 3038267
FIX: Error “[BC30494] line is too long” occurs when you upload an SSRS report to Reporting Services Report Manager Reporting Services
SQL Server MSDN KB Number 3038331
FIX: Query that contains subscription parameters is fired multiple times when you create a new subscription in SSRS Reporting Services

SQL Server MSDN KB Number 3044160
FIX: Performance counters under “ReportServer:Service” object show zero in SSRS 2014 Reporting Services
SQL Server MSDN KB Number 3013553
FIX: Insufficient memory error when you run an XML Validation Control Flow task on a large input file in SSIS 2012 or SSIS 2014 Integration Services
SQL Server MSDN KB Number 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 or SQL Server 2014 MDS
SQL Server MSDN KB Number 3050636
FIX: Cannot schedule a subscription in an SSRS 2012 or SSRS 2014 report when the data source is SAP NetWeaver BI type 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 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 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

 

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

MSDN Support KB Article 3038332
FIX: Data Alerts tables are filled up and never clear old data when you use alerts for SSRS 2012 or SSRS 2014 reports Reporting Services
MSDN Support KB Article 3042544
FIX: A query that requires nested loops join takes longer to complete in SQL Server 2014 SQL performance
MSDN Support KB Article 3044958
FIX: Rollback recovery on a snapshot fails when you run DBCC CHECKDB and then SQL Server shuts down unexpectedly SQL service

MSDN Support KB Article 3029776
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension Analysis Services
MSDN Support KB Article 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
MSDN Support KB Article 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service SQL service

MSDN Support KB Article 3034492
FIX: “Call to Excel Services returned an error” error when you refresh the document in the PowerPivot Gallery Analysis Services
MSDN Support KB Article 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source Integration Services
MSDN Support KB Article 3032476
FIX: Memory leak in USERSTORE_SCHEMAMGR and CPU spikes occur when you use temp table in SQL Server 2012 or 2014 SQL service
MSDN Support KB Article 3042683
FIX: Data Tools error occurs when you upgrade a DTS package in SQL Server 2014 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

 

List of Bugs Fixed in SQL Server 2014 CU6 – 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) 6 for Microsoft SQL Server 2014.

MSDN Support KB Article 3027847
FIX: Date conversion error when you use German SQL Server 2014 MDS in a German Windows operating system MDS
MSDN Support KB Article 3027860
Error 17066 or 17310 during SQL Server startup SQL service
MSDN Support KB Article 3028216
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014 Analysis Services
MSDN Support KB Article 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

MSDN Support KB Article 3028322
FIX: It takes longer time than usual to render a report in SSRS 2012 or SSRS 2014 Reporting Services
MSDN Support KB Article 3029126
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube Analysis Services
MSDN Support KB Article 3029762
FIX: Access violation occurs when you delete rows from a table that has clustered columnstore index in SQL Server 2014 SQL service

MSDN Support KB Article 3029825
FIX: DBCC CHECKDB and DBCC CHECKTABLE take longer to run when SQL CLR UDTs are involved in SQL Server 2012 or SQL Server 2014 SQL performance
MSDN Support KB Article 3029977
FIX: OS error 665 when you execute DBCC CHECKDB command for database that contains columnstore index in SQL Server 2014 SQL service
MSDN Support KB Article 3030041
FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014 Setup & Install
MSDN Support KB Article 3030325
FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh Analysis Services
MSDN Support KB Article 3030326
FIX: Entries are no longer recorded on history page when you customize data refresh in 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

 
1 2