New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. is against this unjust law - help us

A Space for All Things .NET Related

Transaction Isolation Levels

By James Hippolite, in , posted: 11-Feb-2009 13:55

I was trying to think of an easy way to memorise/understand these.  What do others think of this approach?
Transaction Isolation LevelLost UpdateDirty ReadNon-Repeatable ReadPhantom ReadsShared LocksSchema Stability LockAlternate RealityUpdate Conflicts
Read committedNNYYAcquired for read, released immediately N 
Read uncommittedNYYYNot acquired for readAcquiredN 
Repeatable readNNNYAcquired for read, held for duration N 
SerializableNNNNLocks range or entire table N 
SnapshotNNNNNot acquired for read YY
Read committed snapshotNNYYNot acquired for read YN
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft  SQL Server(TM) 2005 (Self-Paced Training Kits)

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.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
New Zealand

Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".