Memory-optimized Tables & Native Stored Procedures

SQL Server 2016
  • 11 Videos | 52m 37s
  • Includes Assessment
  • Earns a Badge
Likes 11 Likes 11
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

  • Playable
    1. 
    Memory-optimized Tables Overview
    4m 55s
    UP NEXT
  • Playable
    2. 
    Creating Memory-optimized tables
    4m 49s
  • Locked
    3. 
    Durability Settings
    4m 40s
  • Locked
    4. 
    Statistics for Memory-optimized tables
    3m 38s
  • Locked
    5. 
    Querying Memory-optimized tables
    4m 1s
  • Locked
    6. 
    Natively Compiled Stored Procedures
    3m 52s
  • Locked
    7. 
    Use Cases for Natively Compiled Stored Procedures
    3m 5s
  • Locked
    8. 
    Atomic Blocks
    4m 57s
  • Locked
    9. 
    Creating Natively Compiled Stored Procedures
    4m 50s
  • Locked
    10. 
    Monitoring Performance
    4m 56s
  • Locked
    11. 
    Best Practices
    3m 23s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 57 Likes 57  
Likes 38 Likes 38  
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Functions
Likes 16 Likes 16  
Likes 141 Likes 141  
Likes 38 Likes 38