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

SQL Server MSDN KB Number 4775394
FIX: Access violation and unexpected SQL Server shutdown occur when common criteria compliance is enabled SQL service
SQL Server MSDN KB Number 4999045
FIX: An Access Violation occurs when a query uses ISNUMERIC functions in Join conditions in SQL Server 2014 Service Pack 1 SQL performance
SQL Server MSDN KB Number 5181898
FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server 2012 or 2014 database SQL service

SQL Server MSDN KB Number 5181900
FIX: Error 2601 occurs when you add new articles with join filters to existing merge publications SQL service
SQL Server MSDN KB Number 5181902
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 5181933
FIX: Hash or merge join hints may be ignored when you execute a query in SQL Server 2012 or SQL Server 2014 SQL performance

SQL Server MSDN KB Number 4837970
FIX: An online rebuild of indexes is unsuccessful when a table partition is read-only in SQL Server 2014 Service Pack 1 SQL service
SQL Server MSDN KB Number 4741544
FIX: Maintenance Plan performs offline index rebuild for large object table in SQL Server 2012 or SQL Server 2014 Management Tools
SQL Server MSDN KB Number 5067465
FIX: TDE certificate creation fails in SQL Server 2014 SP1 if the serial number is greater than 16 bytes SQL security

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

SQL Server MSDN KB Number 4867179
FIX: “Cannot Start Application” error occurs when you start SQL Server Reporting Services Report Builder in SQL Server 2014 Service Pack 1 Reporting Services
SQL Server MSDN KB Number 4741577
FIX: A crash occurs when proactive caching is triggered for a dimension in SSAS 2012 or SSAS 2014 Analysis Services
SQL Server MSDN KB Number 4741535
FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS 2012 or SSAS 2014 Analysis Services

SQL Server MSDN KB Number 4737114
FIX: An internal error occurs in Power View when it is used to access an SSAS 2012 or SSAS 2014 multidimensional cube Analysis Services
SQL Server MSDN KB Number 4737059
FIX: SSAS 2012 or SSAS 2014 crashes when a writeback commit transaction and batch processing are executed concurrently Analysis Services
SQL Server MSDN KB Number 4584553
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

SQL Server MSDN KB Number 4584517
FIX: Table values change after dividing and partitioning the table in SQL Server Analysis Services Analysis Services
SQL Server MSDN KB Number 4744189
FIX: The bcp utility may crash when you use SQL Server 2012 or SQL Server 2014 SQL connectivity
SQL Server MSDN KB Number 4767653
FIX: An AlwaysOn database on a secondary replica shows a “NOT SYNCHRONIZING” status in SQL Server 2014 High Availability
SQL Server MSDN KB Number 4921039
FIX: “Possible schema corruption. Run DBCC CHECKCATALOG” error occurs when you delete column 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 SP1 CU2 – 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 2 (SP 1 CU2) for Microsoft SQL Server 2014.

SQL Server MSDN KB Number 4737005
FIX: Database corruption after you perform a ProcessData and then ProcessRecalc operation in SSAS 2012 or SSAS 2014 Analysis Services
SQL Server MSDN KB Number 4736989
FIX: Non-admin role cannot receive correct ChildCount estimates for parent/child dimension leaf members in SSAS Analysis Services
SQL Server MSDN KB Number 4736988
FIX: Instance of SSAS 2012 or SSAS 2014 crashes when cube writeback commit and processing transactions are executed at the same time Analysis Services

SQL Server MSDN KB Number 4584562
FIX: Memory consumption increases quickly and surpasses HardMemoryLimit when you run a query in Many-To-Many dimension Analysis Services
SQL Server MSDN KB Number 5159952
FIX: Increased HADR_SYNC_COMMIT wait types when AlwaysOn Availability Groups contain memory-optimized tables in SQL Server 2014 Service Pack 1 High Availability
SQL Server MSDN KB Number 5020141
FIX: A stalled dispatcher system dump occurs forcing a failover and service outage on the availability groups in SQL Server 2014 Service Pack 1 High Availability

SQL Server MSDN KB Number 5181955
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 or 2014 SQL performance
SQL Server MSDN KB Number 5181937
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 5181930
FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll 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 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

 
1 2