O'Reilly logo

Getting Started with SQL Server 2014 Administration by Gethyn Ellis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Memory-optimized tables

The following quote is from the SQL Server 2014 documentation:

"SQL Server In-Memory OLTP helps improve performance of OLTP applications through efficient, memory-optimized data access, native compilation of business logic, and lock- and latch free algorithms. The In-Memory OLTP feature includes memory-optimized tables and table types, as well as native compilation of Transact-SQL stored procedures for efficient access to these tables."

Much like traditional tables, memory-optimized tables offer fully durable transactions and meet ACID (Atomic Consistent Independent and Durable) by default and are designed to help databases that require really fast performance.

Much like the name suggests, memory-optimized tables are stored ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required