Memory-optimized Tables & Native Stored Procedures

SQL Server 2016    |    Intermediate
  • 11 videos | 47m 7s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 27 users Rating 4.6 of 27 users (27)
Improve the overall performance of your SQL Server 2016 databases. Explore memory-optimized tables as well as native stored procedures, a feature used to enable efficient execution of the queries.

WHAT YOU WILL LEARN

  • Create memory-optimized tables
    Optimize performance by adjusting durability settings
    Describe considerations for statistics on memory-optimized tables
    Describe the methods used to query memory-optimized tables
    Describe the characteristics of natively compiled stored procedures
    Recognize best-case usage scenarios for natively compiled stored procedures
  • Describe atomic blocks in natively compiled stored procedures
    Demonstrate how to create a natively compiled stored procedure
    Demonstrate how to monitor performance for natively compiled stored procedures
    Describe the best practices for calling natively compiled stored procedures
    Demonstrate how to troubleshoot deadlocks

IN THIS COURSE

  • 4m 55s
    In this video, learn how to create tables that are optimized for memory. FREE ACCESS
  • 4m 49s
    Learn how to optimize performance by adjusting durability settings. FREE ACCESS
  • Locked
    3.  Durability Settings
    4m 40s
    Upon completion of this video, you will be able to describe considerations for statistics on memory-optimized tables. FREE ACCESS
  • Locked
    4.  Statistics for Memory-optimized tables
    3m 38s
    After completing this video, you will be able to describe the methods used to query memory-optimized tables. FREE ACCESS
  • Locked
    5.  Querying Memory-optimized tables
    4m 1s
    After completing this video, you will be able to describe the characteristics of stored procedures that are compiled natively. FREE ACCESS
  • Locked
    6.  Natively Compiled Stored Procedures
    3m 52s
    After completing this video, you will be able to recognize best-case usage scenarios for stored procedures that are compiled natively. FREE ACCESS
  • Locked
    7.  Use Cases for Natively Compiled Stored Procedures
    3m 5s
    After completing this video, you will be able to describe atomic blocks in stored procedures that are compiled natively. FREE ACCESS
  • Locked
    8.  Atomic Blocks
    4m 57s
    In this video, you will learn how to create a stored procedure that is compiled natively. FREE ACCESS
  • Locked
    9.  Creating Natively Compiled Stored Procedures
    4m 50s
    In this video, you will learn how to monitor performance for stored procedures that are compiled natively. FREE ACCESS
  • Locked
    10.  Monitoring Performance
    4m 56s
    After completing this video, you will be able to describe the best practices for calling stored procedures that are compiled natively. FREE ACCESS
  • Locked
    11.  Best Practices
    3m 23s
    In this video, you will learn how to troubleshoot deadlocks. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database, 3rd Edition
Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Course Performance Engineering: Optimizing Database Performance
Rating 4.3 of 22 users Rating 4.3 of 22 users (22)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Automation Design & Robotics
Rating 4.3 of 993 users Rating 4.3 of 993 users (993)
Course Isolation Levels
Rating 4.5 of 31 users Rating 4.5 of 31 users (31)
Course Stored Procedures
Rating 4.6 of 64 users Rating 4.6 of 64 users (64)