Tag Info

New answers tagged


Does REPEATABLE READ preclude Write Skew? Yes - if you buy into the Critique's view that the ANSI definitions were based on locking behaviours, for example: Remark 6. The locking isolation levels of Table 2 and the phenomenological definitions of Table 3 are equivalent. Put another way, PO, PI, P2, and P3 are disguised redefinitions of Locking ...


Though, I don't remember any reference mentioned in BOL thus can't provide it here but as per my understanding it is related to locking. Higher level of isolation level can cause locking issues. READ COMMITTED ISOLATION is more towards write locks than read, which fits good in OLTP environment when compared to OLAP. Commercial databases decides default ...

Top 50 recent answers are included