data-konzept

'The default transaction level in sql server 2012 is READ COMITTED. That transaction level uses a pessimistic approach meaning readers can block writers, writers can block writers and writers can block readers.
Is it basically the opposite approach of optimistic approaches like providing row versions i.e. snapshot isolation level.

However in this session we want to focus on how SQL Server maintains consistency in a multi-user environment. The answer is simple: locks.'...

http://dirtyread.de/comments.php?aid=7