There is a new great WIKI ressource for common T-SQL solutions at MSDN Code Gallery, it's called SQLExampels.

In this WIKI presented information, represents the suggestions, ideas, and opinions of Volunteer Moderators and Answerers (you know Arnie Roland and many more) who support the Microsoft MSDN SQL Server Forums.

I'm sure this will be a great ressource for SQL Server professionals. So check it out: http://code.msdn.microsoft.com/SQLExamples

CU tosc