From the course: Microsoft SQL Server 2016 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
In-memory tables - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
In-memory tables
- In this section we're going to talk about in-memory tables. In-memory tables are also known as memory-optimized tables. As the same implies, this is a special type of table where all data remains in memory. Therefor, the database engine does not have to read from disc to access this table, the data will already be in memory. This provides a significant performance improvement, and Microsoft recommends using in-memory tables when we'd like to improve the performance of transactions. In other words, both reading and writing data. If you're looking to improve the performance of read-only operations, for that, Microsoft recommends the Columnstore index. This is recommended for reporting and other types of read-only access. We'll talk about that later in the course, but for now we're going to do a demo on in-memory tables. I've staged some code for you in the exercise files. If you want to take all of that code and copy it into a new Query window in SQL Server Management Studio. Let's…
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.