Re:Microsoft SQL Server 2016 Express
by serguzest on Wednesday October 12, 2016 @12:51PM
(#12694470)
It uses tempdb for tracking versions, it is not true mvcc in the engine.
That's an internal detail. It's much cleaner than postgresql that leaves old tuples in disk and has to vacuum them later.
https://msdn.microsoft.com/en-us/library/ms173763.aspx