From the course: Developing Microsoft SQL Server 2016 Databases
Join today to access over 25,500 courses taught by industry experts.
Why use in-memory tables? - SQL Server Tutorial
From the course: Developing Microsoft SQL Server 2016 Databases
Why use in-memory tables?
- [Instructor] Traditional data tables are stored on disks and are subject to the physical constraints of accessing data off of spinning platters. New solid state drive removes some of this bottle neck, but for the best read and write performance, you'll want to investigate the use of in-memory tables. It may seem obvious but in-memory or memory optimized tables are simply tables that reside in the server's main system memory rather than on disk. This makes them extremely fast and less prone to blocking and locking contention issues that can disrupt a slower disk-based table when multiple transactions are being applied simultaneously. By default, in-memory tables are fully durable which means that they can survive a critical server fault or crash without losing data. They do this by persisting a second copy of the table to disk as a backup which the server will reload into memory after a reset. Of course, this means that 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.
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.