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

SQL Server MSDN KB Number 3068439
FIX: Indexed view returns incorrect result after insert or delete operation on the base table in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3068468
FIX: Schema lock occurs on a table with large data when you delete lots of rows from it in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3068703
FIX: Error messages are logged when you execute a non-cacheable auto-parameterized query in SQL Server 2012 SQL service

SQL Server MSDN KB Number 3068776
FIX: Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3069154
FIX: You cannot set a SQL Server 2012 database to single-user mode if the database is read-only SQL service
SQL Server MSDN KB Number 3069155
FIX: A deadlock occurs when you execute the sp_estimate_data_compression_savings stored procedure in SQL Server 2012 SQL service

SQL Server MSDN KB Number 3073530
FIX: Access Violation error occurs when you run DDL SQL statements on a database in an instance of SQL Server 2012 Analysis Services
SQL Server MSDN KB Number 3074434
FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory SQL service
SQL Server MSDN KB Number 3074535
FIX: The Resource database is missing after you install updates or service packs for instances of SQL Server 2012 one after another and then restart the server 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 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 2 Cumulative Update 1 (SP 2 CU 1) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2881285
You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014 Integration Services
SQL Server MSDN KB Number 2928300
FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server SQL performance
SQL Server MSDN KB Number 2932559
FIX: Totals are wrong after you filter on a pivot table item and remove the filter in SSAS 2012 or SSAS 2014 Analysis Services

SQL Server MSDN KB Number 2933103
FIX: Assertion failure when you execute a query specifying TOP N and ORDER BY in SQL Server SQL performance
SQL Server MSDN KB Number 2936154
FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server Management Tools
SQL Server MSDN KB Number 2936984
FIX: “Failed to generate dynamic snapshot” when you call sp_MScreatemergedynamicsnapshot in SQL Server SQL service

SQL Server MSDN KB Number 2938192
FIX: The execution of SSIS package takes a long time when you cannot enable garbage collector server mode in SSIS 2012 or SSIS 2014 Integration Services
SQL Server MSDN KB Number 2950209
FIX: Access violation when the start offset is larger than the string length in Substring function in SQL Server SQL service
SQL Server MSDN KB Number 2952101
FIX: Poor cardinality estimation when the ascending key column is branded as stationary in SQL Server SQL performance
SQL Server MSDN KB Number 2953354
FIX: Log Reader Agent fails when you have Oracle Publishing configured in SQL Server 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 CU2 – 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 2 (SP 2 CU 2) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2924996
FIX: Issues when you export a report to PDF that has Unicode fonts in SQL Server 2008 R2 or SQL Server 2012 SQL service
SQL Server MSDN KB Number 2952260
FIX: New FILESTREAM Filegroup can’t be recognized when you alter a partition function with SPLIT RANGE in SQL Server SQL service
SQL Server MSDN KB Number 2958054
FIX: SQL Cache Memory decreases and CPU usage increases when you rebuild an index for a table in SQL Server SQL service
SQL Server MSDN KB Number 2962767

FIX: “Cannot insert duplicate key” error occurs when you update a table by using a bitmap index that contains a partition key in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 2963137
FIX: Incorrect result is returned when you query multiple dimension members in MDX and DAX in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 2963408
FIX: Error 5180 occurs when you query BLOB column data in SQL Server SQL service
SQL Server MSDN KB Number 2963668

FIX: w3wp.exe process crashes during merge replication with SQL Server Compact subscribers and precomputed partitions SQL service
SQL Server MSDN KB Number 2965069
FIX: Incorrect result when you execute a query that uses WITH RECOMPILE option in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 2965654
FIX: SSRS 2012 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
SQL Server MSDN KB Number 2965758
FIX: Memory leak occurs when you start and stop an XEvent session repeatedly 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 CU3 – 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 3 (SP 2 CU 3) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3001713
FIX: The .csv file contains field separators when you export a report that has a tablix that has no data in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 3002071
FIX: “System objects could not be updated…” error when you use AlwaysOn Availability Groups feature in SQL Server 2012 High Availability
SQL Server MSDN KB Number 3002883
FIX: Error in OpenFileStream API when you open FILESTREAM data that is hosted on dynamic disks in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3003102
FIX: The date value in the Last Run column is blank in Report Manager Details View in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 3004355
FIX: SQL Server crashes when you retrieve an SQL statement hash for logging XEvent in SQL Server 2012 SQL service

SQL Server MSDN KB Number 3006648
FIX: Data corruption occurs in target table when you use a SQL Server destination in a data flow component in SSIS 2012 SQL service
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 3008416
FIX: Duplicate records in the report rendering when you use Lookup function in the expression of a matrix in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 3009576
FIX: Cannot restore database by using the full backup and differential backup files that contain defunct files SQL service

SQL Server MSDN KB Number 3009883
FIX: Error when you execute statistics update on a table that has sql_variant data type in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3010773
FIX: Power View report plots values incorrectly for line chart in SSRS 2012 in SharePoint integrated mode SQL service
SQL Server MSDN KB Number 3011807
FIX: Large chain of blocking occurs when you use merge replication in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3012182
FIX: Log_Send_Rate column in sys.dm_hadr_database_replica_states cannot reflect the rate accurately in SQL Server 2012 High Availability

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 CU3 – 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 3 (SP 2 CU 3) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3009974
FIX: Slow AG synchronization when disks have different sector sizes for primary and secondary replica log files in SQL Server 2012 SQL service
SQL Server MSDN KB Number 2973961
FIX: Non-convergence or merge agent failure occurs when you use a custom stored procedure resolver in SQL Server SQL service
SQL Server MSDN KB Number 2975743
FIX: Incorrect result and exception occur when you use MDX query to do session cube grouping in SSAS Analysis Services

SQL Server MSDN KB Number 2981424
FIX: Exception when you select more than one hierarchy from parent/child dimension with naming template in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 2982019
FIX: Error when you restart the Merge Agent after you upgrade the Publisher to SQL Server 2012 SP2 SQL service
SQL Server MSDN KB Number 2982544
FIX: Slow to access “Explorer” or “System Administration” on MDM home page Data Quality Services (DQS)

SQL Server MSDN KB Number 2986722
FIX: Error 7105 when you execute UPDATE on sparse column set while ONLINE INDEX REBUILD is running on the same table in SQL Server SQL performance
SQL Server MSDN KB Number 2987935
FIX: Long wait on CLR_CRST when you execute spatial query that is under heavy load in SQL Server SQL service
SQL Server MSDN KB Number 2988667
FIX: Query results keep unchanged when filter is applied in a parent-child dimension with unary operators 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 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 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 Service Pack 1 Cumulative Update 1 (SP 1 CU1) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 3024790
FIX: SQL Server 2012 SP2 CU2 cannot install the SQL Writer update when the SQL Server is non-English version Setup & Install
SQL Server MSDN KB Number 3020350
FIX: ISServerExec crashes when you execute an SSIS package that contains another set of child SSIS packages Integration Services
SQL Server MSDN KB Number 3052167
FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014 SQL performance

SQL Server MSDN KB Number 3054180
FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 2867316
FIX: You cannot restore a SQL Server 2012 or 2014 database in the Microsoft Azure binary large object storage service SQL service
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 MDS for SQL Server 2012 or SQL Server 2014 MDS
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 3020750
FIX: Error or blank page when you click the workbook link under “Data Refresh – Recent Activity” Analysis Services
SQL Server MSDN KB Number 3023620
FIX: Continuous refreshes occur after you configure scheduled 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

 

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

SQL Server MSDN KB Number 3066682
FIX: Error occurs when you filter data with date format that differs from DateTime attribute format setting in MDS 2014 MDS
SQL Server MSDN KB Number 3063438
FIX: XSLT transformation fails when you execute an SSIS 2014 package that contains multiple concurrent XML tasks Integration Services
SQL Server MSDN KB Number 3048734
FIX: An I/O error that occurs on BPE files causes SQL Server 2014 to disable BPE SQL service

SQL Server MSDN KB Number 3036601
FIX: Add three stored procedures to clean up history that is created when you use SQL Server 2012 or 2014 MDS MDS
SQL Server MSDN KB Number 3036328
FIX: The value of statement_start_offset column is incorrect in DMV sys.dm_exec_requests in SQL Server 2014 SQL service
SQL Server MSDN KB Number 3067828
FIX: Access violation occurs when you connect to an instance of SQL Server 2014 SQL service

SQL Server MSDN KB Number 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
SQL Server MSDN KB Number 3067896
Incorrect results are returned in an indexed view after an Insert or Delete operation on the base table occurs in SQL Server 2014 SQL performance
SQL Server MSDN KB Number 3033041
FIX: Error occurs and the execution hangs when you run an SSIS package that connects to Flat File Source Integration Services
SQL Server MSDN KB Number 3061218
FIX: “Cannot read 8 bytes from file using caching” error when you execute an SSIS 2014 package 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

 
1 2