Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Optimizing SQL Server Procedures: Best Practices and Performance

via Pluralsight

Overview

Manipulating the data from SQL Server is something that every data professional should know. However, manipulating the SQL Server data by using stored procedures in an efficient and performant way is
a mastery on its own!

There is a huge difference between stored procedures that just work, and stored procedures that work efficiently. In this course, Optimizing SQL Server Procedures: Best Practices and Performance, you’ll gain the ability to design and maintain highly performant T-SQL stored procedures. First, you’ll explore when and how to start troubleshooting your stored procedures. Next, you’ll discover why it is of key importance to read and understand execution plans and how to implement efficient indexing strategies. You’ll also understand the benefits and caveats of the parameter sniffing feature, as well as how to handle errors in the most efficient way. Finally, you’ll learn how to optimize stored procedures in various scenarios and how to avoid the most common pitfalls when writing your T-SQL procedures. When you’re finished with this course, you’ll have the skills and knowledge of stored procedures optimization in SQL Server needed to manipulate the data from SQL Server in the most efficient and performant way.

Syllabus

  • Course Overview 1min
  • Understanding Common Performance Challenges with Stored Procedures 22mins
  • Optimizing Stored Procedures in Real-life Scenarios 8mins

Taught by

Nikola Ilic

Reviews

4.7 rating at Pluralsight based on 12 ratings

Start your review of Optimizing SQL Server Procedures: Best Practices and Performance

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.