Simplifying Histogram Generation with Single CASE Statement in GROUP BY

Understanding the Pitfalls of Using Common Table Expressions in DELETE Statements

Optimizing FIFO Matching of Two Datasets in T-SQL: Converting from "While" Loop to Set-Based Logic or CTE

How to Calculate Running Total of "Due" Jobs in SQL Server 2012: Recursive Queries and Cursors Compared