- Course
Practical SQL Server In-Memory OLTP Tables and Objects
A practical approach to understanding the benefits and requirements of implementing in-memory OLTP tables, indexes, natively compiled stored procedures, and UDFs. This course also treats support, monitoring, and troubleshooting IMOLTP.
- Course
Practical SQL Server In-Memory OLTP Tables and Objects
A practical approach to understanding the benefits and requirements of implementing in-memory OLTP tables, indexes, natively compiled stored procedures, and UDFs. This course also treats support, monitoring, and troubleshooting IMOLTP.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
In-memory OLTP objects have created some of the most drastic performance improvements of any SQL Server feature introduced to date. Further improvements from its initial "hekaton" release to the modern version of SQL Server makes this feature not only more robust, but puts this approach within reach of the every-day DBA and database developer. In this course, Practical SQL Server In-memory OLTP Tables and Objects, you will learn the foundational make-up of SQL Server in-memory objects and what you need to leverage these objects in your projects. You'll also learn to avoid pitfalls common to working with in-memory, as well as some of the myths surrounding in-memory objects, identifying where they do and do not offer a benefit. This practical approach focuses on real world usage but gives the user a moderately deep overview of internals as well. By the end of this course, you will understand what you need to implement in-memory objects and how they can benefit you.
Practical SQL Server In-Memory OLTP Tables and Objects
-
Intro | 2m 55s
-
Traditional Table Storage | 3m 14s
-
Traditional Storage Limitations | 2m 51s
-
Memory Optimized Row Storage | 4m 11s
-
Memory Optimized Isolation Levels and Navigation | 4m 48s
-
Memory Optimized Durability | 4m 36s
-
Checkpoint File Pairs | 2m 58s
-
Checkpoint File Pair Lifecycle | 6m 30s
-
Memory Optimized Limitations | 4m 21s