Here is my similarly themed article, albeit about a different maligned technique:

http://www.sqlservercentral.com/articles/Advanced+Querying/2596/

Bottom line, one always needs to know what to optimize for. More times than many people realize, raw speed of execution is not at the top of the list.