Retrieving the data from SQL Server in an efficient and performant way is a mastery of its own! In this course, Understanding Query Optimization in SQL Server, you’ll gain the ability to create and maintain efficient and performant T-SQL queries. First, you’ll explore when and how to start troubleshooting your queries. Next, you’ll discover why it is important to read and understand query plans and how plan caching features may speed up query execution. You’ll also understand the benefit of having a proper indexing strategy and up to date statistics. Finally, you’ll learn how to optimize T-SQL queries in various scenarios and how to avoid the most common pitfalls when writing your T-SQL code. When you’re finished with this course, you’ll have the skills and knowledge of query optimization in SQL Server needed to retrieve the data from SQL Server in the most efficient and performant way.
Author Name: Nikola Ilic
Author Description:
Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI – but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed “Data-Mozart”. As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer’s last name as part of his nickname. That’… more

Table of Contents

• Course Overview
  1min
• Introducing Query Optimization in SQL Server
  18mins
• Understanding Query Plans
  11mins
• Understanding Plan Reuse and Plan Cache
  11mins
• Understanding Indexing and Statistics
  22mins
• Optimizing Ad-hoc Expressions and Parameterization
  10mins
• Understanding Plan Guides and Query Hints
  7mins