Combining many crossing intervals

This article demonstrates how the geometric functions in SQL can be use to solve the Islands and Gaps problem.

The Triple Update

Gap Analysis Using Algebra

This article shows how to solve a gaps and islands problem using simple algebra.

Implementing Date Calculations in SQL

This article explains a way to use labels (last year, YTD, etc.) for report parameters.

Introduction to STRING_SPLIT function in SQL

This article explains the T-SQL function STRING_SPLIT() and demonstrates a creative use for it.

Casting Tiny Numbers

Mean Median Mode using SQL and DAX

This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.

Exploring the DATE Functions in SQL

Learn more about using the DATEADD function in SQL...

Identity Guarantees

Introduction to Indexed Views in SQL Server

This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.