sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

sp_helpindex2

modernized sp_helpindex with info on post S2K features

Mechanism To Dynamically Build Pivot Table

Script to build PIVOT queries with an arbitrary number of columns

sp_spaceused2

extensions to sp_spaceused

Detect and Repair Non Trusted Foreign Keys

Create the code to detect and repair non trusted foreign keys

View Server Roles and Permissions per Login

obtain server roles and permissions by login

How to Identify backup tables within production databases

How to identify backup tables within production databases that can be removed.

number of rows and columns of an instance

Get the number of rows, columns, and space used by all tables in all databases

Data Collections restart and clear cache files

Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.

Conditionally Order By Different Column

Order records based on a different column depending on which absolute value is greater.