Do you want to know why the Query Optimizer chooses one execution plan
Presented by Maciej Pilecki at SQLBits VII