Reading an older overview of CouchDB published on the IBM site HERE, I was surprised to find the following:
Most modern databases have started to move from locking mechanisms to MVCC, including Oracle (since V7), MySQL (when used with InnoDB) and Microsoft® SQL Server 2005 and later.
I am using SQL Server quite a bit at the moment (V2012) and never considered that there may be any form of MVCC. I have also used
with (tablock, holdlock) in stored procedures before.
Does SQL Server really implement MVCC anywhere and how does that reconcile with the idea of
with (tablock, holdlock) if it does?