Using Memory-optimized Tables and Native Stored Procedures

Focused View

Pinal Dave

1:58:21

23 View

01 - Course Overview

01 - Course Overview.mp4

01:25

02 - Creating Memory Optimized Tables

02 - Introduction.mp4

00:54

03 - What Is In-Memory OLTP.mp4

01:27

04 - In-Memory OLTP Components.mp4

03:32

05 - Incorrect Assumptions.mp4

05:29

06 - Use Cases.mp4

05:03

07 - Demo - Creating Memory Optimized Table.mp4

06:49

08 - Summary.mp4

01:20

03 - Optimizing Performance of In-Memory Tables

09 - Introduction.mp4

02:21

10 - How Memory Optimized Tables Perform Faster.mp4

03:31

11 - Trade-Offs.mp4

02:57

12 - Compatibility Level.mp4

01:15

13 - Demo - Compatibility Level.mp4

03:05

14 - Memory Optimized FileGroup.mp4

01:14

15 - Demo - Memory Optimized FileGroup.mp4

04:20

16 - Snapshot Isolation Level.mp4

01:21

17 - Demo - Snapshot Isolation Level.mp4

04:10

18 - Indexes on Memory Optimized Tables.mp4

02:06

19 - Nonclustered Index and Hash Index.mp4

01:28

20 - Demo - Nonclustered Index and Hash Index.mp4

08:15

21 - Summary.mp4

01:59

04 - Creating Natively Compiled Stored Procedures

22 - Introduction.mp4

01:09

23 - Natively Compiled Stored Procedures.mp4

01:01

24 - Use Cases.mp4

01:57

25 - Limitations.mp4

03:05

26 - Comparison of Stored Procedure.mp4

03:48

27 - Demo - Natively Compiled Stored Procedures.mp4

05:30

28 - Demo - Interpreted Stored Procedures - Executions.mp4

03:13

29 - Demo - Errors and Resolutions.mp4

03:56

30 - Demo - Joins and Natively Compiled Stored Procedures.mp4

05:18

31 - Summary.mp4

01:18

05 - Collecting Execution Statistics for Natively Compiled Stored Procedure

32 - Introduction.mp4

00:56

33 - Challenges.mp4

01:40

34 - Resolutions.mp4

01:58

35 - Demo - Enabling Execution Statistics.mp4

03:14

36 - Demo - Collecting Execution Statistics.mp4

04:55

37 - Summary.mp4

01:03

06 - Summary

38 - Agenda.mp4

00:44

39 - In-Memory OLTP.mp4

02:18

40 - Demo - Convince Your Boss.mp4

05:21

41 - Final Note.mp4

01:56

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Database Programming

Microsoft SQL

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.