Impact of LEAP Second on SQL Server Databases

SQLServerF1

SQL Server is not really impacted by the leap second. Most affected systems by the second leap are those based on Linux and Java, and those that depends heavily on replicated data. Windows based systems do not seem affected by the second leap as they use Windows Time Service through external NTP Time Server. It is recommended that Systems admins sync domains controllers rather than waiting till next synchronization, which might take up to one week. SQL Server database engine is also not affected by the second leap, as it is reading time through the OS.

Most applications also will not be affected by the second leap, as they don’t depend on seconds in calculations. Some of the systems might get affected, especially those that might be real-time systems or those that depend on seconds on their internal calculations. Money Markets systems, and similar ones, such as securities, FX, derivatives and electronic trading systems that channel orders in real-time might get impacted by the second leap. However, this is depending on systems architectures and the way orders are channeled through local markets, international markets, Bloomberg or Reuters.

In most cases, timestamps and execution orders are handled by intermediate systems or market systems, and therefore we do not really need to worry about it.
In case specific critical application or system needs to be reviewed, it is suggested to do a thorough study to application architecture, timing dependencies, and code review if necessary.

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

SQL Server MSDN KB Number 2960310
FIX: Access violation when you maintain RBS with the .NET Framework 4.0 in related configuration file in SQL Server SQL service
SQL Server MSDN KB Number 2960735
FIX: Windows Update for SQL Server 2012 or SQL Server 2014 image does not work in Microsoft Azure Virtual Machine gallery Setup & Install
SQL Server MSDN KB Number 2960989
FIX: Error when you use DQS Cleansing component with large batch in an SSIS 2012 or SSIS 2014 package DQS
SQL Server MSDN KB Number 2961254
FIX: The execution of an MDX query in SSAS 2012 or SSAS 2014 is much slower than it is in SSAS 2008 R2 Analysis Services

SQL Server MSDN KB Number 2961525
FIX: Keyboard keys do not work for Report Viewer 2012 in a Windows Forms application Reporting Services
SQL Server MSDN KB Number 2961559
FIX: Incorrect folder when deploying SQL Server 2012 PowerPivot solutions by using SharePoint 2013 Central Admin Analysis Services
SQL Server MSDN KB Number 2962650
FIX: Access violation occurs when running a Process Recalc on a tabular table in SSAS 2012 or SSAS 2014 Analysis Services

SQL Server MSDN KB Number 2963138
FIX: Parallel deadlock or self-deadlock occurs when you run a query that results in parallelism in SQL Server 2012 SQL service
SQL Server MSDN KB Number 2963372
FIX: Sub-total of calculated measure is incorrect (non-filtered) when you execute MDX query in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 2963373
FIX: Performance regression when you operate on a string or Boolean column by using DAX functions in SQL Server 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 2012 SP2 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 2 Cumulative Update 1 (SP 2 CU 1) for Microsoft SQL Server 2012.

SQL Server MSDN KB Number 2954861
FIX: “Query Timeout Expired” when you preview a command of an SSIS package in SSDT 2012 Integration Services
SQL Server MSDN KB Number 2956619
FIX: The execution of an SSIS package that is stored in MSDB is slower than it is stored on the file system Integration Services
SQL Server MSDN KB Number 2950189
FIX: An access violation occurs when you execute update query on a table that has a DML trigger in SQL Server SQL service
SQL Server MSDN KB Number 2957768

FIX: Excel rendering extension produces corrupted files when rendering a NaN or Infinity value in SSRS 2012 Reporting Services
SQL Server MSDN KB Number 2957957
FIX: Attributes sort incorrectly after you use the Attribute Properties function in SQL Server 2012 MDS Add-in for Excel Data Quality Services (DQS)
SQL Server MSDN KB Number 2958012
FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012 SQL service

SQL Server MSDN KB Number 2958062
FIX: Error 515 when you add a subscription and then delete it in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 2959342
FIX: Data-driven subscription can’t be created when the driving query takes longer than 30 seconds to execute in SQL Server 2012 Reporting Services
SQL Server MSDN KB Number 2960237
FIX: Error when you execute DQS stored procedure [internal_core].[RestoreDQDatabases] in SQL Server DQS

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

SQL Server MSDN KB Number 2988166
FIX: Additional semicolons are added to object definition when you run Invoke-Sqlcmd in SQL Server 2012 Management Tools
SQL Server MSDN KB Number 2989590
FIX: Except function does not return the calculated member that is created at the ALL member level in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 2989704
FIX: Some columns in sys.column_store_segments view show NULL value when the table has non-dbo schema in SQL Server SQL service
SQL Server MSDN KB Number 2989810
FIX: Error when you use bcp_init to do BCP and use local temp table as input parameter in SQL Server Native Client 11.0 SQL service

SQL Server MSDN KB Number 2991526
FIX: SSIS XML Source task fails to load the data from URI in SQL Server 2012 Integration Services
SQL Server MSDN KB Number 2991528
FIX: SSIS package execution fails when it uses DT_TEXT data type after you apply SQL Server 2012 SP2 Integration Services
SQL Server MSDN KB Number 2992069
FIX: XMLA and Windows PowerShell return different code for the same SSAS 2012 processing Analysis Services
SQL Server MSDN KB Number 2992414

FIX: Error in SQL task with IsQueryStoredProcedure set to True when you use .NET Data Provider for Teradata in SSIS 2012 Integration Services
SQL Server MSDN KB Number 2993262
FIX: Some rows are missing in the result when you run query to select data from Oracle linked server by using merge join SQL performance
SQL Server MSDN KB Number 2993483
FIX: SSAS 2012 processing fails when you perform a Process Full operation on many partitions in a transaction Analysis Services
SQL Server MSDN KB Number 2993529
FIX: Business rule validation fails with collation mismatch error in SQL Server 2012 MDS DQS

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

SQL Server MSDN KB Number 2979121
FIX: Log Reader Agent fails when you upgrade from SQL Server 2008 to SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 2979304
FIX: Error when you run RBS Maintainer in SQL Server 2012 SQL service
SQL Server MSDN KB Number 2980395
FIX: A severe error occurs when you run a query that uses CTEs against the partitioned tables in SQL Server 2012 SQL performance

SQL Server MSDN KB Number 2984249
FIX: Null fields are returned when the dataset in SSRS retrieves a stored procedure with required parameters Reporting Services
SQL Server MSDN KB Number 2986423
FIX: It takes a long time to add new columns to a table when the row size exceeds the maximum allowed size SQL service

SQL Server MSDN KB Number 2986627
FIX: UPDATE STATISTICS performs incorrect sampling and processing for a table with columnstore index in SQL Server 2012 SQL performance
SQL Server MSDN KB Number 2987809
FIX: Report format is misaligned when you view the report that has certain report items in Internet Explorer 11 Reporting Services
SQL Server MSDN KB Number 2987812
FIX: No information about extensive lock conflicts in the SSAS msmdsrv.log file 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 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 2973561
FIX: Error when you insert a record into a FileTable or FILESTREAM in SQL Server 2012 or SQL Server 2014 SQL service
SQL Server MSDN KB Number 2973921
FIX: “allow mixed content” popup when you use PowerView that contains map data in SSRS 2012 on SharePoint website Reporting Services
SQL Server MSDN KB Number 2975322
FIX: Blank value is set to NULL value in a business rule in MDS of SQL Server 2012 or SQL Server 2014 Data Quality Services (DQS)

SQL Server MSDN KB Number 2975385
FIX: User obtains incorrect data when two users in the same security role run the same client report in SSAS 2012 Analysis Services
SQL Server MSDN KB Number 2975498
FIX: Cannot view Power View sheet from SharePoint 2013 when a workbook uses certain Korean characters as file name Reporting Services
SQL Server MSDN KB Number 2976953
FIX: The DAX query with filter returns incorrect result after you run a DAX query without any filters in SSAS 2012 Analysis Services

SQL Server MSDN KB Number 2976966
FIX: Cannot install the Windows Forms application that has ReportViewer control Reporting Services
SQL Server MSDN KB Number 2977271
FIX: Performance improvement for SQL Server Spatial data access in SQL Server 2012 SQL service
SQL Server MSDN KB Number 2977312
FIX: Incorrect result when you use LIKE pattern to match the Japanese repeat character (Cho-On) 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 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 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

 
1 2 3 4 7