Here you will find below marvelous pinches like
1) real time issue with approaches taken by people
2) some great and mind blowing solutions and explanations for #1.
3) great linked article and other same scenarios experienced by other people.
4) people will tell you what you did wrong.
5) last but not least. masters will tell you; what and where to hit ;-)
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)