SQL Server 2014 news – Delayed durability

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

Every new version of SQL server contains a some new features and the most significant features of SQL server 2014 is the in-memory OLTP tables and Clustered Column Store index. But there are some other less known, but interesting features of SQL Server 2014.

SQL Server 2014 introduces the ability to reduce latency by designating some or all transactions as delayed durable. A delayed durable transaction returns control to the client before the transaction log record is written to disk. Durability can be controlled at the database level, COMMIT level, or ATOMIC block level.

For more information see the topic Control Transaction Durability.