Accelerated Database Recovery
Accelerated Database Recovery (ADR) is poised to be one of the biggest updates to SQL Server in the last few years. ADR introduces in-line row versioning, which allows long running transactions (such as an offline clustered index rebuild, or a large insert/update/delete statement) to be rolled back immediately. This will help with a few things