You find you are querying a vendor supported database where you're not allowed to make any collation changes, and which has a weird collation setup: default DB collation that matches your server and other databases all character related columns are explicitly a different collation that does not match your DB or server collation Rather than […]
2019-07-05 (first published: 2019-06-26)
4,390 reads
2010-06-23 (first published: 2008-12-24)
37,400 reads
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...
Day 1 is an absolute thrill at re:Invent! I normally dedicate this dynamic day...
With all the changes that have happened with VMware since the Broadcom acquisition I...
Comments posted to this topic are about the item Adding a Lot of Seconds
Comments posted to this topic are about the item SQL Server Licensing is Simple,...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers