Here is a very useful resource.  From SQL Server Query Optimization team lots of hints on query performance.   I found the link to this on Magnum B.I. I thought I would share this with you.  I get lots of questions relating to query performance.