Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.

Filtered Index vs Indexed View

Dynamic Management Functions

Unravel Some Complex IF Logic

A Simple Recursion Finds Joins

When you need to find all the related rows and tables to a parent table, here's one way you might approach the problem.

DBCC CHECKIDENT

New Year's Eve

All the rows before this one

T-SQL Arithmetic and Geometric Sequence (Series)

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)