I have to say that I have been spoiled for some time now. Up until my most recent job, I have gotten to work with DBA's on my projects for the previous 3 years or so. Consequently my SQL had gotten rusty. Recently I have had to re-remember how to get data out of sys-comments and such and I stumbled across these two blogs:
Shailen Sukul - http://geekswithblogs.net/shailensukul/archive/2006/05/26/79685.aspx
And this one:
http://vadivel.blogspot.com/2005/11/list-of-my-sql-articles-tips.html