The ordering of the data

@@CURSOR_ROWS -m Flag

PARSENAME and Input Length

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.