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, ...

SQL Server supports three recovery models: Simple, Bulk-Logged, and Full. The Simple model does not support transaction log backups and is suitable for scenarios where data loss is acceptable.