SQL
Techniques
Search for everything starting with .. (include nulls)
Temporary table to simplify search
Output parameters
Classic Insert New Record and Return the Key
Retrieve the last record in a secondary table
Replace in Text fields
Identify Memory Hungry Indexes or Processes
Shrink Transaction Logs
Random Numbers in SELECT
Enumerate a list of records
Attach/Detach Database
List Maintenance Plan Failures (SQL2000)
Investigating Blocks
Reference
Date Formats
Get size of database