The Number Subquery

The Full OFFSET

Never, Ever, Ever Start T-SQL Comments with Two Dashes

In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.

Navigating Trees With CTE

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]

Numbers to Letters

Output Parameters

Preventing Trigger Execution

What is interpolation?

In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.

NULLIF and 0

Scripts to Automate Creating and Loading a SQL Server Table

Use these T-SQL strategies for dropping, creating, and populating tables in custom schemas across different SQL Server versions from SQL Server 2019 back to SQL Server 2005.