From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

In memory tables

In memory tables - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

In memory tables

- Microsoft SQL Server has a new feature launched in 2014 called in-memory tables. And these are tables that live primarily in memory rather than living primarily on the hard drive. And this can provide a significant performance increase for your most heavily used tables. I've staged some code for use to create an in-memory table. You want to go to your exercise files and copy and paste all of that into a new query window. Make sure you're executing against the LyndaDemo database. And before we run the code, let's look at it. Lines one and two, we'll create a new file group and we'll need to specify that file group contains memory-optimized data. Lines five, six, and seven, we'll add a file to the file group. I've put my file at a particular path, the default path for storing data files in SQL Server 2014. The path on your computer might be a little different if you installed to a different directory or a different drive. And then lines ten through fourteen actually create the table…

Contents