3-Minute Test: What do you know about SQL performance?
The following questions provide examples that might make you believe that SQL tuning is black magic. The explanations at the end are just a few sentences long and reveal that the black magic is pure science.
Source: 3-Minute Test: What do you know about SQL performance?
Some interesting questions and good explanations. (I got 4 out of 5. :) )