Finding Lowercase Characters

A Strange View

Long Wait(for)s

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.