|Transaction Isolation Level||Lost Update||Dirty Read||Non-Repeatable Read||Phantom Reads||Shared Locks||Schema Stability Lock||Alternate Reality||Update Conflicts|
|Read committed||N||N||Y||Y||Acquired for read, released immediately||N|
|Read uncommitted||N||Y||Y||Y||Not acquired for read||Acquired||N|
|Repeatable read||N||N||N||Y||Acquired for read, held for duration||N|
|Serializable||N||N||N||N||Locks range or entire table||N|
|Snapshot||N||N||N||N||Not acquired for read||Y||Y|
|Read committed snapshot||N||N||Y||Y||Not acquired for read||Y||N|
Other related posts:
Teach Yourself Azure in 4 hours
Geek Post Monthly Newsletter Volume 2 Issue 10
Comment by Kirk Jackson, on 11-Feb-2009 23:18
Very nice. Thanks, Kirk
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.