Some of the moderators over at the MSDN SQL Server Forums have got together and collated a reference of solutions to common T-SQL problems.
As always, all quality resources get added to the SQL Server Resrouces area of this site.
About John Sansom
I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!