Craig Freedman has a few posts that explains some of the pitfalls of the different isolation levels, very interesting stuff:

• Read Committed Isolation Level
• Query Plans and Read Committed Isolation Level
• Repeatable Read Isolation Level

A developer really should understand the implications of this, it is tripped me in the past, rather painfully.