There are many times when a developer realises that this snippet is not performing the way it was expected to . This happens as early as dev or unit testing cycle . This is the best time to get hold of those performance bottlenecks by using the most accessible performance tuning option "The Graphical Execution Plan".
It is a one click operation to get to the plan but the terms like Seek, scan , Book mark Lookup , RID lookup and many more soon start puzzling the developer.

This session is aimed at making the developer aware of those terms and using this knowledge decipher the plan.
Presented by Ashwani Roy at SQLBits IV
Slide Deck 497 KB
WMV Video 107 MB