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.
Course info
Level
Intermediate
Updated
Jul 10, 2019
Duration
1h 59m
Table of contents
Description
Course info
Level
Intermediate
Updated
Jul 10, 2019
Duration
1h 59m
Description

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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
MariaDB Functions Playbook
Advanced
1h 42m
Nov 13, 2019
MariaDB Data Manipulation Playbook
Intermediate
1h 35m
Nov 12, 2019
More courses by Pinal Dave
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
(Music) Hi everyone. My name is Pinal Dave. Welcome to my new course, Using Memory-optimized Tables and Native Stored Procedures. I am a SQL Server performance tuning expert at sqlauthority.com. In-Memory OLTP technology provides us the ability to optimize the performance of the last transaction processed in a fraction of the time. This course is a quick introduction to two of the major components of SQL Server's In-Memory OLTP technology, memory-optimized tables and natively compiled stored procedures, commonly known as native stored procedures. You just need a basic understanding of SQL Server for this course. Some of the major topics that we will cover are creating memory-optimized tables, optimizing performance of in-memory tables, creating natively compiled stored procedures, collecting execution statistics for natively compiled stored procedures, and finally, a summary. By the end of this course, you will have a solid foundation to get started with In-Memory OLTP technology. I have included a very interesting demonstration in the last module, which I call Convince Your Boss. I hope you will join me in this journey to learn memory-optimized tables and natively compiled stored procedures, at Pluralsight.