Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,609 reads
David Strack
Blogs
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Steps for a Successful Data Migration Session at Microsoft Ignite
By kleegeek
I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...
Daily Coping 2 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Using mode() in R
Comments posted to this topic are about the item Using mode() in R
Machine Learning Services on Database Server verses R Lang Execution on Laptop
We are running SQL Server 2017 (RTM) on Windows. The question came up, if...
Stored Procedure "Caching"
I'm having an issue with a database that I recently moved from SQL 2014...
Ask SSC