SQL Server In-memory story

In-memory table was introduced in SQL Server 2014. This powerful technology allows usto take advantage of large amounts of memory and CPU cores to increase performance by upto 30 to 40 times! The biggest improvements are due to completely new storage mechanisms, optimistic concurrency with no locking or latching for any operations and native compilation of stored procedures. There were few limitation of using In memory objects such as tables and indexes. SQL Server 2016 removes many of the limitations found in SQL Server 2014, and enhancing internal processing algorithms so that In-memory OLTP can provide even greater improvements.

The below a execellent comparison table by Aaron Bertrand for SQL server 2014 and SQL Server 2016.