I was going through one white paper recently and thought its good. A lengthy one but discusses lot of aspects with performance tuning.
(May be more suited for a DBA and not developer as its not concentrated around tuning the queries only)
http://technet.microsoft.com/en-us/library/cc966540.aspx#EDAA
---------------------------------------------------------------------------------