Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?

T-SQL Powers

Nanoseconds

Print Text Month Calendar

This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.

Deleting Duplicate Records

In Datawarehousing, a normal scenario is eleminating duplicate records/rows or deleting duplicate records, here's the solution.

Routine Dependency Visualizer

This article contains a T-SQL script that can show you the dependency of all objects in your SQL Server database.

Parsing values in the WHERE clause

SELECT (Transact-SQL)

Changing Identity Columns

Table Variables