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
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free


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.

Sign up for free
Someone learning on their laptop while sitting on the floor.