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.

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.

• Course Overview 1min
• Creating Memory Optimized Tables 24mins
• Optimizing Performance of In-Memory Tables 38mins
• Creating Natively Compiled Stored Procedures 30mins
• Collecting Execution Statistics for Natively Compiled Stored Procedure 13mins
• Summary 10mins