Great article Jeff. Another developer had a stored procedure that was run daily to create a report. The stored procedure took 3 hours to run. The SP had multiple "death by SQL" updates in it. After rewriting the code, the sp now takes 2 minutes (max) to run.
I was a beginner at SQL when I ran across this article, and I have used this technique in many queries.