Transaction Isolation Levels

Craig Freedman has some great posts giving a thorough explanation of transaction isolation levels within SQL server

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

Any enterprise builder should consider taking a look at these. Not fully understanding your isolation lever design can help you avoid the dreaded deadlock scenario, or worse.