TechEd AU this week. I'm giving a talk on "T-SQL Tips n Techniques: Improving Your T-SQL Arsenal" on Friday morning. The slides are available from CommNet for people registered, but the scripts are here as well. Come along to the talk to see how I use the scripts, but do grab these if you want to be trying them out on your data while I present. They all work on SQL Server 2005, and they use the AdventureWorks database.
I'll also try to do a series of blog posts about some of the tips, but as well as that, many of them are part of the Advanced T-SQL course that I put together earlier in the year.