From the course: Developing Microsoft SQL Server 2016 Databases

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Create a memory-optimized table

Create a memory-optimized table - SQL Server Tutorial

From the course: Developing Microsoft SQL Server 2016 Databases

Start my 1-month free trial Buy for my team

Create a memory-optimized table

“

- [Instructor] In-memory tables are created within a special file group in the database. This file group will get a location on disk in order to save the backup table in order to maintain durability. However, by specifying that the file group contains memory optimized data, the server will use main system memory as the primary storage location. Let's see how to implement this in a new database that I'll call memory optimized tables. Then we're going to alter the new database that we just created and we're going to add a new file group. I'll call the file group MOT_MOD and that's just a name that I came up with that combines MOT which stands for Memory Optimized Tables and MOD to define that it contains Memory Optimized Data. Then we'll just specify that it contains and then memory optimized data again with the underscores. Let's go ahead and alter our database to add in that new file group. Then we need to give this file…

Contents