Andrew Pruski tries out a new feature:
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieves this is documented here.
Now in SQL Server 2025 we can switch on ADR for tempdb!
Read on to see what benefits you can get.