The most common method on the internet for combining DATE and TIME columns in SQL Server is incorrect. This article demonstrates why that and other methods are incorrect and two lesser known high performance methods that produce correct results even for the "edge cases".
2023-08-07
21,824 reads
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
31,984 reads
2016-09-06
1,146 reads
2016-08-24
1,277 reads
2012-06-06
3,078 reads
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Has the PK been used...
Comments posted to this topic are about the item Has the PK been used...
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers