I spend 30 precious minutes every Friday reading my SQL Server Central articles and attempting the QotD. This is the first time I cheated (IMHO) and ran the code for...

Your question was not just about stored procs, but about "tricks to being a highly productive SQL Programmer", so I'll think outside of the box.

#1 - I frequently use information_schema...