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

SQL Server MSDN KB Number 2989043
FIX: Access denied when you view report history on a SharePoint site with the View Items permission Reporting Services
SQL Server MSDN KB Number 2989478
FIX: Poor performance for cdc.fn_cdc_get_net_changes_ in SQL Server 2012 SP2 SQL performance
SQL Server MSDN KB Number 2989512
FIX: MDX query returns no result when the cache is not cleared after you run a previous query in OLAP or tabular model Analysis Services
SQL Server MSDN KB Number 2990152
FIX: Unexpected Simplified Chinese characters appear in TextData field of Distributed Replay trace in SQL Server Management Tools

SQL Server MSDN KB Number 2994993
FIX: Text in a hyperlink in its own paragraph is not indexed in full-text in SQL Server 2012 SQL service
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 report Reporting Services
SQL Server MSDN KB Number 2995622
FIX: “Specified cast is not valid” error when you load an XML document that has time zone information in SSIS 2012 Integration Services

SQL Server MSDN KB Number 2996729
FIX: “Non-yielding Scheduler” condition occurs when you run a complex query in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 2997392
FIX: INSERT performance decreases in merge replication that uses precomputed partitions in SQL Server 2012 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 3000835
FIX: “An internal error occurred on the report server” error when you export a report to a .pdf file in SSRS 2012 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 2012 SP2 CU4 – 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 4 (SP 2 CU4) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2793580
FIX: An update enables you to exclude system databases from Query Statistics collection sets when you use the management data warehouse in SQL Server Management Tools
SQL Server MSDN KB Number 2840657
FIX: Performance decreases when you stage many records in MDS for SQL Server 2012 Master Data Services (MDS)
SQL Server MSDN KB Number 2970136
FIX: Cannot remove backup file after you restore the database from Windows Azure in SQL Server 2014 or SQL Server 2012 SQL service

SQL Server MSDN KB Number 2994082
FIX: Error when you edit models for some groups or users in SQL Server 2012 MDS MDS
SQL Server MSDN KB Number 2995352
FIX: “No catalog entry found for partition ID in database ” error when you use SQL Server 2012 SQL service
SQL Server MSDN KB Number 2995622
FIX: “Specified cast is not valid” when you load an XML document that has time zone information in SSIS 2012 or SSIS 2014 Integration 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 Reporting Services
SQL Server MSDN KB Number 2998870
FIX: “The record ID is incorrect” error when you use DAX to execute query in a dimension in SSAS 2012 or SSAS 2014 Analysis 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

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 7

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 3035165
FIX: Error 8646 when you run DML statements on a table with clustered columnstore index in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3040804
FIX: “Access Denied” error occurs when you run an XML validation task in SSIS 2012 or SSIS 2014 Integration Services
SQL Server MSDN KB Number 3041476
FIX: SQL Server takes long time to open database after recovery to add or remove a data file in SQL Server 2014 or SQL Server 2012 SQL service

SQL Server MSDN KB Number 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
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 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 3048856
FIX: Error 3624 occurs when you execute a query that contains multiple bulk insert statements in SQL Server 2014 SQL service

SQL Server MSDN KB Number 3051663
FIX: “8156: A database error has occurred” when you run a business rule in SQL Server 2014 Master Data Services MDS
SQL Server MSDN KB Number 3052244
FIX: Incorrect result when the “must be unique” action is evaluated for an attribute by using SQL Server 2014 Master Data Services MDS
SQL Server MSDN KB Number 3020402
FIX: SQL Server 2014 Object Explorer does not display the SQL Azure objects correctly Management Tools
SQL Server MSDN KB Number 3029504
FIX: “Error converting data type nvarchar to datetime” error occurs when you use business rule in SQL Server 2014 MDS MDS

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 6

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 3025845
FIX: The transaction isolation level is reset incorrectly when the SQL Server connection is released in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3026083
FIX: SOS_CACHESTORE spinlock contention on ad hoc SQL Server plan cache causes high CPU usage in SQL Server 2012 or 2014 SQL service
SQL Server MSDN KB Number 3027232
FIX: Error when you schedule data refresh by defining Secure Store ID in SQL Server PowerPivot for SharePoint 2013 Analysis Services

SQL Server MSDN KB Number 3030041
FIX: Error occurs when you connect to the database engine after you install CU4 for SQL Server 2014 Setup & Install
SQL Server MSDN KB Number 3030325
FIX: The scheduled refresh only occurs every other day instead of every day in SQL Server 2014 PowerPivot data refresh Analysis Services
SQL Server MSDN KB Number 3030326
FIX: Entries are no longer recorded on history page when you customize data refresh in PowerPivot for SharePoint 2013 Analysis Services

SQL Server MSDN KB Number 3030619
FIX: Incorrect data returned when you query the DATE column in SQL Server 2014 SQL service
SQL Server MSDN KB Number 2999809
FIX: Poor performance when a query contains table joins in SQL Server 2014 Management Tools
SQL Server MSDN KB Number 3034615
FIX: Memory leak occurs when you run DBCC CHECKDB against a database in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3035071
FIX: Error when you run a query that contains “Use database_name” or “Execute Stored_Procedure_name” command 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

 

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

SQL Server MSDN KB Number 3053752
FIX: PowerPivot Gallery displays Create Power View Report button incorrectly when you use SSAS 2014 as a data source Analysis Services
SQL Server MSDN KB Number 3067659
FIX: Data loss might occur when you use Windows Azure Storage in SQL Server 2014 on high latency networks SQL service
SQL Server MSDN KB Number 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014 SQL service

SQL Server MSDN KB Number 3071024
“Alter failed for Database” error occurs when you enable the “Change Tracking” option for the Azure SQL Database in SQL Server Management Studio 2014 Management Tools
SQL Server MSDN KB Number 3045410
FIX: A query that uses the DECRYPTBYKEY function takes a long time in SQL Server 2014 SQL security
SQL Server MSDN KB Number 3042683
FIX: Data Tools error occurs when you upgrade a DTS package in SQL Server 2014 Integration Services

SQL Server MSDN KB Number 3042370
An AlwaysOn secondary replica crashes or raises error 3961 when the AlwaysOn database has CLR UDT in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3039035
FIX: “Parameter type cannot be deduced” when you execute sp_describe_undeclared_parameters in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 3061685
FIX: Cannot create statistics when you execute statement to create it directly or in the background in SQL Server 2014 SQL performance
SQL Server MSDN KB Number 3037624
FIX: Complex parallel query does not respond in SQL Server 2012 or 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 CU8 – 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) 8 for Microsoft SQL Server 2014.

MSDN Support KB Article 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
MSDN Support KB Article 3067968
FIX: Paging out in memory occurs when columnstore index query consumes large memory in SQL Server 2014 SQL service
MSDN Support KB Article 972759
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem Management Tools

MSDN Support KB Article 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
MSDN Support KB Article 3066682
FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014 MDS
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 3026954
FIX: CatalogFolder.DeployProject takes longer time to be complete when you deploy a project in SQL Server 2014 or SQL Server 2012 Integration Services
MSDN Support KB Article 3035737
FIX: SSAS instance crashes when cube writeback commit transaction and processing batch are executed at the same time Analysis Services
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 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators 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 CU8 – 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) 8 for Microsoft SQL Server 2014.

MSDN Support KB Article 3069488
“Non-yielding Scheduler” error occurs and SQL Server stops responding when a database has columnstore indexes on a Microsoft SQL Server 2014 instance SQL service
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 or SQL Server 2012 SQL connectivity
MSDN Support KB Article 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

MSDN Support KB Article 3045333
FIX: “C2 Audit mode” option cannot be enabled by using sp_configure and restarting SQL Server SQL security
MSDN Support KB Article 3043889
FIX: The chart in SSRS 2012 or SSRS 2014 report is not updated correctly when you update the parameter in the URL of the report Reporting Services
MSDN Support KB Article 3042629
FIX: Error 33415 occurs when you restart the SQL Server service or alter database in SQL Server 2012 or SQL Server 2014 SQL service

MSDN Support KB Article 3036201
FIX: The notification email link is broken when a special character is part of the URL in SQL Server 2012 or SQL Server 2014 MDS Master Data Services(MDS)
MSDN Support KB Article 2999809
FIX: Poor performance when a query contains table joins in SQL Server 2014 Management Tools
MSDN Support KB Article 3070147
Incorrect values are included in the description column when you query the sys.dm_xe_objects dynamic management object in SQL Server 2014 SQL service
MSDN Support KB Article 3048734
FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE 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

 
1 2