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 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 1 Cumulative Update 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 4814178
FIX: 401 error occurs when you try to connect to an MDS solution by using MDS Add-in for Excel MDS
SQL Server MSDN KB Number 5181962
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
SQL Server MSDN KB Number 5181906
FIX: Installing SQL Server 2008 Service Pack 1 may reset the “max_worker_threads” column value for a SQL Server Agent subsystem Management Tools

SQL Server MSDN KB Number 4812206
FIX: Cannot find file error occurs when you execute a maintenance plan to back up database in SQL Server 2014 SQL service
SQL Server MSDN KB Number 5181968
FIX: Incorrect results from the CHANGETABLE() function when snapshot isolation is enabled for a SQL Server 2012 or 2014 database SQL service
SQL Server MSDN KB Number 5181959
Can’t install SQL Server by using InstallShield or bootstrapping application Setup & Install

SQL Server MSDN KB Number 5181957
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 or 2014 Master Data Services to start the workflow Data Quality Services (DQS)
SQL Server MSDN KB Number 5181924
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 or SQL Server 2014 SQL performance
SQL Server MSDN KB Number 5181916
FIX: CMEMTHREAD waits occur when you execute many ad hoc queries in SQL Server 2012 or 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 2012 SP2 – 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 2 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 714689
Evaluation results are written to output xml file multiple times when you implement Enterprise Management Framework against multiple servers and an error occurs against one of the servers in the list.
SQL Server MSDN KB Number 735543
Database goes into a restore mode when its backup is restored as a different database on the same instance.
SQL Server MSDN KB Number 736509
You cannot debug a stored procedure that calls sp_executesql in SQL Server Management Studio (SSMS). When F11 is pressed, you receive an ‘Object reference not set to an instance of object’ error message.

SQL Server MSDN KB Number 740181
SSMS does not fully manage Full-Text in SQL Server Express.
SQL Server MSDN KB Number 745566
SQL Server SMO ignores default constraint in SQL Server 2012 and SQL Server 2014.
SQL Server MSDN KB Number 764197
SSMS handles Numbered Stored procedures inconsistently.
SQL Server MSDN KB Number 769121

“Column ‘‘ does not belong to table summary. (System.Data)” error message when replicating tables have the same names but are located in different schemas.
SQL Server MSDN KB Number 773710
After reverting to a database snapshot that contains full-text indexes, you cannot create any ft_catalogs until you either restart SQL Server, detach and then attach the database, or take the database offline and then set the database online.
SQL Server MSDN KB Number 774317
SSMS occasionally crashes on close, which then causes it to automatically restart

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 – 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 Service Pack 2 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 1374617
FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 Failover Cluster installation
SQL Server MSDN KB Number 1610447
Uninitialized object leads to crashes and potentially wrong results when executing DAX expressions with conditional calculations.
SQL Server MSDN KB Number 1610492
A simple DAX query returns unexpected results when you use PowerPivot v2 11.0.3000.0.
SQL Server MSDN KB Number 2060218
“ACTIONABLE_HEAP_CORRUPTION” when SSRS configuration file is parsed by using an invalid InstanceId.
SQL Server MSDN KB Number 2065570
NonYieldProcessTable record in RING_BUFFER_NONYIELD_PROCESSTABLE ring buffer does not have user and kernel process time.

SQL Server MSDN KB Number 2075161
Provides platform information in the log of SSRS 2012
SQL Server MSDN KB Number 1347204
FIX: Access Violation when you insert data into a table that has a column with a sequence default from a cross-database transaction in SQL Server 2012
SQL Server MSDN KB Number 1184332
If a tail log backup is performed against the model database, model database will freeze in restoring state during a server restart that will prevent the SQL Server from starting successfully. This is because Tempdb database could not be created during the server startup and you receive the following error message: “Database ‘‘ cannot be opened”
SQL Server MSDN KB Number 1243853
Error 3456 occurs when restoring the log backup of a bulk-logged DB where a new data file was added with an initial size greater than 64704KB.

SQL Server MSDN KB Number 1404999
When you drop of a database snapshot is issued in a session with a LOCK_TIMEOUT setting, a time-out error may occur followed by an assertion error.
SQL Server MSDN KB Number 1190211
Installation of SQL Server by using InstallShield ends up in a hang state. For more information, go to this Knowledge Base article.
SQL Server MSDN KB Number 1386073
After you install SQL Server 2012 SP2, when SQL Server is stopped from either configuration manager or service control manager, an informational message is logged to the SQL Server immediately after shutdown is issued. In earlier versions, we issued this messages after internal services, such as the .NET Framework, service broker, were stopped.

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 – 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 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2952444
FIX: Poor performance when you use table variables in SQL Server 2012
SQL Server MSDN KB Number 2936328
FIX: Access violation occurs when you run CHECKTABLE or CHECKDB against a table that has persisted computed columns in SQL Server 2008 R2 or SQL Server 2012
SQL Server MSDN KB Number 2827857
FIX: DTA does not work on SQL Server 2012 instance that uses a supplementary character collation

SQL Server MSDN KB Number 2939277
FIX: Incorrect results when you run queries that contain UNION operator by using parallel query plan in SQL Server
SQL Server MSDN KB Number 950185
Improved messaging around processing errors and warnings when you work with large HTML reports.
SQL Server MSDN KB Number 950189
Improved messaging around processing errors and warnings when you work with reports with large number of parameters.

SQL Server MSDN KB Number 994470
Incorrect results when you work with block mode unary operators.
SQL Server MSDN KB Number 1041277
DPM’s full backup on the server with AlwaysOn secondary will be converted to copy_only backup.
SQL Server MSDN KB Number 1278767
The value of tabular instance perfmon counters: Memory\VertiPaq KB is always 0.
SQL Server MSDN KB Number 1355346
The end SCOPE statement does not match the opening SCOPE statement.

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 – 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 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2963412
New DMF sys.dm_fts_index_keywords_position_by_document in SQL Server 2012 SP2
SQL Server MSDN KB Number 2966520
FIX: New log files are not created when you restart the Reporting Services Windows Service in SSRS 2012 on January 1
SQL Server MSDN KB Number 2966519
FIX: No error message when log backup failed in SQL Server 2012

SQL Server MSDN KB Number 2936004
FIX: Visual Studio 2012 crashes because of access violation when the data source binding is completed in Report Viewer 2012 UI in local mode
SQL Server MSDN KB Number 2966522
FIX: File Share subscription doesn’t populate the description column in SSRS 2012
SQL Server MSDN KB Number 2966523
FIX: The “Name” drop-down list is empty when an SSRS 2012 report is specified

SQL Server MSDN KB Number 2964762
FIX: Event ID 22 or error 0xC1000016 will be logged when you use Discover command in SSAS 2012
SQL Server MSDN KB Number 2972285
FIX: Performance issues when you use SSISDB as your deployment store in SQL Server 2012
SQL Server MSDN KB Number 2965035
SSAS 2012 logging feature improvement in SQL Server 2012 Service Pack 2

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 – 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 for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2028830
FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 or SQL Server 2012 Failover Cluster installation
SQL Server MSDN KB Number 2963382
FIX: Can’t connect to the server when you run a cube creation MDX query in SSAS 2012
SQL Server MSDN KB Number 2927741
FIX: Image is not displayed correctly in the webpage when you use DrillThrough action on an SSRS 2012 report

SQL Server MSDN KB Number 2963383
FIX: Text truncated when you use HPB renderer to view a report in SSRS 2012
SQL Server MSDN KB Number 2963384
FIX: SQL Server crashes when the log file of tempdb database is full in SQL Server 2012
SQL Server MSDN KB Number 2963386
FIX: SSRS 2012 fails with IsolatedStorageException when subscriptions exported to Excel worksheets are larger than 10 MB

SQL Server MSDN KB Number 2963388
FIX: SSRS 2012 cannot export a report that is larger than 10 MB to Excel format
SQL Server MSDN KB Number 2963404
FIX: Rollback causes database to go to suspect mode in SQL Server 2012
SQL Server MSDN KB Number 2806979
FIX: Poor performance when you run a query against a table in an RCSI-enabled database in SQL Server 2012

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 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 Service Pack 2 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3063438
FIX: XSLT transformation fails when you run an SSIS 2014 package that contains multiple concurrent XML tasks Integration Services
SQL Server MSDN KB Number 2965654
FIX: SSRS 2012 or SSRS 2014 report is cut horizontally after you apply Update MS13-088 on a computer Reporting Services
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 SQL service

SQL Server MSDN KB Number 3066299
FIX: Non-English items display in the MDS Explorer when you set language settings for web browser to English Master Data Services (MDS)
SQL Server MSDN KB Number 3069320
FIX: A workflow never starts in a SharePoint 2013 environment when you use SQL Server 2012 Master Data Services to start the workflow MDS

SQL Server MSDN KB Number 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
SQL Server MSDN KB Number 2820068
Can’t install SQL Server by using InstallShield or bootstrapping application Setup & Install

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 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 Service Pack 2 Cumulative Update 7 (SP 2 CU 7) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 3074922
FIX: Incorrect result when you execute a full-text query with parallel execution plan in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 3074425
FIX: Contention occurs when you execute many ad-hoc queries in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3075176
FIX: You receive incorrect results from the CHANGETABLE() function when snapshot isolation for a SQL Server 2012 database SQL service

SQL Server MSDN KB Number 3076444
FIX: Cannot enable “change data capture” on a table that uses a unique index with more than one included column in SQL Server 2012 SP2 SQL service
SQL Server MSDN KB Number 3075669
FIX: SSAS 2012 crashes when you execute an MDX query that contains a large number of Union expressions Analysis Services
SQL Server MSDN KB Number 3051243
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service

SQL Server MSDN KB Number 3064292
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 SQL service
SQL Server MSDN KB Number 3073907
FIX: A SQL Server 2012 SSIS package with an Execute SQL Task may stop responding 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 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

 
1 2 3 4 5 11