Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.

Finding “Active” Rows for the Previous Month (SQL Spackle)

SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.

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