[saltcured]

It's also deeply entwined with the MVCC concurrency control and the ability to do DDL in transactions, right?

[jiggawatts]

SQL Server supports every combination of heap storage, clustered storage, MVCC, and DDL in transactions.