I have found almost every day of my career at Microsoft, I learn something new about Microsoft SQL. It is one of the reasons I enjoy my job. In April of 2023, I was speaking at the MVP Summit in Redmond, Washington. One day I was spending time in a side conversation with MVP Rob Farley discussing some of his « wish list » items for SQL. One of these wish list items was delayed transaction durability for tempdb.
Delayed transaction durability is the concept of lazily flushing changes from the transaction log on disk after a transaction commit. This concept