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

Write review

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access


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.2 rating at Pluralsight based on 46 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.