SQL Server In-Memory Tables

SQL Server In-Memory Tables(Hekaton) Andy Novick April 2015

SQL Server 2014 aimed to improve OLTP performance by adding In-Memory tables and native compilation of the stored procedures that use them.  In-Memory tables bring incredible speed for the right workload so long as a series of limitations can be observed.  This presentation describes what In-Memory tables are and how they’re implemented in a way that retains the ACID database properties that we rely on in disk based tables.  We’ll discuss:

  • How In-Memory tables are persisted
  • How data is exchanged with disk based tableSQL Server In-Memory Tables(Hekaton) Andy Novick April 2015s
  • Limitations of natively compiled stored procedures that achieved maximum performance
  • How far do In-Memory tables allow us to go.
  • Interactions with the delayed durability feature of SQL 2014
  • In-Memory @table variables

We’ll also take a look at some of the things that in-memory tables are not intended for and explore how they can be pushed.

Andy Novick is a Boston area consultant, author, and MVP who specializes in developing high performance SQL Server databases and T-SQL code.  He’s been a speaker at Boston area user groups and at SQL PASS for many years.  His web site, NovickSoftware.com, features numerous articles for SQL Server developers.