SQL Server 2014 introduced the concept of in-memory tables. These were optimally designed for high-speed loading of data with no locking issues or high-volume session state issues.

In-Memory Enhancements SQL Server 2014 introduced the concept of in-memory tables. These were optimally designed for high-speed loading of data with no locking issues or high-volume session state ...

New for SQL Server 2016 is the ability to place a Columnstore Index on an In-Memory Table.

New in-memory online transaction processing improvements highlight the new features in the latest Community Technology Preview of SQL Server 2016, the flagship RDBMS from Microsoft.

Non-clustered Columnstore Indexes are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.

One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also ...