The following T-SQL script will extract all data/log files for the currently attached databases, and then scan all of those directories to find files that are not being used by SQL Server. This will quickly locate mdf, ldf or ndf files located in your data and log directories to free up space.

Ever wonder when the last time your table stats where updated (perhaps done automatically because auto_stats is on?).

The following sproc will generate a random complex password, and return it as an output parameter from the caller. Complex means it will be guaranteed to contain one upper and one lower case letter, one number 0-9, and one special character.

Somewhat buried IMHO, the following command will enable network access for DTC, which is off by default. This required when installing SQL Server 2000/2005 and you want to allow for things like remote two-phase commit, linked servers and replication. Hardest part was finding the actual component name to place in the sysocmgr file.