SQL Server TSQL Wiki

Some of the SQL Server MVPs, MSDN Moderators and Answerers are working together to set up a Wiki site to provide solutions to most common TSQL problems. It is a great location to find answers to many of your TSQL problems. It is still at the early stages and there is much content coming up. (I have not contributed anything significant yet, but I will do after I am done with my book.)

 http://code.msdn.microsoft.com/SQLExamples