The guys over at the SQL Server Query Optimization team have started a new blog.  Should be a useful place to pick up some tips and tricks on getting your queries to run at the speed of light.

http://blogs.msdn.com/queryoptteam/