SQL Server Performance Forum – Threads Archive
Dirty Write and pantom read
HI AllI want to Know about two term in Database
1. Dirty Write
2. pantom read how that came into picture in Database enviornment and how to overcome the problem in such case? I aggred my question is therotical. I beg pardan in such case. Thanks in Advance
Sanju SQL is love
Refer to books online ‘isolation levels -> setting’ and also ‘Concurrency Problems’, for some good explanations
True BOL is the startup in this case and refer to thishttp://www.databasejournal.com/features/mssql/print.php/1442301 also for information. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>