Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.

Counting Bits

Sparse Column Defaults

Escaping Like I

The Lesser Used Functions

There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?

SQL Server OPTION RECOMPILE for Simple Queries

Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.

The Funny Dynamic SQL

Why a Self-Join Requires Halloween Protection

I was asked recently why Halloween Protection was needed for data modification statements that include a self-join of the target table. This gives me a chance to explain, while also covering some interesting product bug history from the SQL Server 7 and 2000 days.

Function Defaults

The Random Rows