Using Memory-optimized Tables and Native Stored Procedures
The objective of this course is to help your SQL Server-based applications to run at rapid speed to by taking advantages of In-Memory OLTP Technologies - Memory-optimized Tables and Native Stored Procedures.
What you'll learn
The In-Memory OLTP feature adds a new memory optimized RDBMS engine and a native compiled stored procedure. This new addition adds higher concurrency to the SQL Server and enables it to process a much higher amount of the workload than before. In this course, we will learn about how to get started with the memory optimized tables and build a use case around its effectiveness. Additionally, we will also understand how the efficiency of the stored procedure is increased when we use Native Stored Procedure along with Memory Optimized Tables.
Table of contents
- Introduction 2m
- How Memory Optimized Tables Perform Faster? 4m
- Trade-Offs 3m
- Compatibility Level 1m
- Demo: Compatibility Level 3m
- Memory Optimized FileGroup 1m
- Demo: Memory Optimized FileGroup 4m
- Snapshot Isolation Level 1m
- Demo: Snapshot Isolation Level 4m
- Indexes on Memory Optimized Tables 2m
- Nonclustered Index and Hash Index 1m
- Demo: Nonclustered Index and Hash Index 8m
- Summary 2m
- Introduction 1m
- Natively Compiled Stored Procedures 1m
- Use Cases 2m
- Limitations 3m
- Comparison of Stored Procedure 4m
- Demo: Natively Compiled Stored Procedures 6m
- Demo: Interpreted Stored Procedures - Executions 3m
- Demo: Errors and Resolutions 4m
- Demo: Joins and Natively Compiled Stored Procedures 5m
- Summary 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.