Vinay Thakur - May 2009 - Blogs - SQLServerCentral

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Vinay Thakur

Archives: May 2009

Transaction isolation level

Transaction isolation level:

1. Uncommitted Read (NoLock)

2. Committed Read (blocking)

3. Repeatable Read (phantom)

4. Snapshot (no blocking)

5. Serializable (no blocking)

Dirty Read:(DR)

Non Repeatable Read:(NRR)

Phantom:(P)

Great link:

http://blogs.msdn.com/craigfr/archive/tags/Isolation+Levels/default.aspx

Thanks

Vinay

1 comments, 295 reads

Posted in Vinay Thakur on 19 May 2009