From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,800 courses taught by industry experts.
Memory-optimized columnstore table - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Memory-optimized columnstore table
- [Instructor] SQL Server supports the creation of clustered column store indexes on top of a memory optimized table. This means that you can gain the benefit of both technologies simultaneously. In memory or memory optimized tables are simply tables that are completely stored in the server's main system memory rather than on a hard drive. This makes them extremely fast to access. In-memory tables are created within a special file group in the database, and I have the code listed here to alter the database Kinetico DW and add in the new file group. I'm calling mine Kinetico Mod or Memory Optimized Data. Next, we need the contains keyword followed by memory optimized data. This file group will also get a location on disk in order to save the backup table in order to maintain durability. I have that listed down here in a second alter database command. However, by specifying that this file group contains the memory…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.