Transaction Isolation Levels
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.

Comments
Comment preview