Lost updates concurrency effect
The lost updates is well explained in list of concurrency effect but it was not explained which isolation level can prevent this concurrency problem later in the same chapter. Is read uncommitted the right isolation level. Kalen Delaney book on sql server 2008 internals simply mention that read uncommitted prevent this. Other books present the lost update as solved by the data repeated read isolation level. What is your opinions
? Thanks
|