Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Using Memory-optimized Tables and Native Stored Procedures

via Pluralsight

Overview

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.

Syllabus

  • 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

Taught by

Pinal Dave

Reviews

4.3 rating at Pluralsight based on 41 ratings

Start your review of Using Memory-optimized Tables and Native Stored Procedures

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.