From the course: SQL Server Performance for Developers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
In-memory temp tables - SQL Server Tutorial
From the course: SQL Server Performance for Developers
In-memory temp tables
- Our final topic in temporary objects is in-memory temporary tables. This is a technique made possible by a combination of features in SQL Server 2016, namely row level security and in-memory OLTP. It wasn't possible prior to that to be able to restrict access to an object based on its current session ID the way temporary tables do. This technique you probably haven't seen before, it's not very common in the wild. I have implemented it on a couple of projects, and as you'll see in the demo, it can give you greatly increased throughput to your temporary objects. One other note, these "temporary tables" aren't stored in tempdb, they're stored in your database, and we'll talk a little bit more about the implications of that as we go through this deck and demo. Hekaton, which was the codename of in-memory OLTP. This is a technology that's designed mainly for high throughput write systems. A lot of people associate in-memory with being able to read from disk really fast, but most of the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.