scarydba.com
A Sub-Query Does Not Hurt Performance - Grant Fritchey
Short, check-list style performance tuning advice such as "A sub-query hurts performance" can be horribly wrong. This post addresses that particular issue.
Grant Fritchey