Carl Rabler et al have just released a really nice looking best practives article on how to resolve query perf bottlenecks. Get it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en