SQL Server 2014 hastens transaction processing. By Joab Jackson. Jun 5, 2013 7:05 am PDT. ... SQL Server 2012 then borrowed this columnar processing technique for its own use.

SQL Server 2014 will come with a new in-memory OLTP engine, one built with the company’s Heckaton set of technologies, ... Hekaton has been shown to cut transaction times by 50 times, ...

There are also some transactions which SQL Server will treat as fully durable, no matter what the setting. Some examples of fully durable transactions on SQL Server 2014 include system transactions, ...

SQL Server keeps a buffer of all of the changes to data for performance reasons. It writes items to the transaction log immediately, but does not write changes to the data file immediately.