Great article,
Some times developers just think “my SPs are full functional", but, in most case, no attempt for performance or "locks". When deadlocks occur they just say "my query is ok, the problem is in the database design". This articles are very important for us DBAs when this features happen, and we needed present a solution or been shutting forever.