SQL Server DBA, BI Analyst and Microsoft MVP

SERIES

SQL Server Performance Tuning

Complete series on how to identify and resolve performance issues in SQL Server.

10 posts in this series

Part 1 of 10

SQL Server - Introduction to Performance Tuning Study

September 30, 2017 16 min read

Continue reading

Part 2 of 10

Understanding how indexes work in SQL Server

October 11, 2015 18 min read

Continue reading

Part 3 of 10

SQL Server - How to identify a slow or "heavy" query in your database

July 8, 2018 26 min read

Continue reading

Part 4 of 10

SQL Server Performance Tuning Tips - Implicit Conversion: Never Again

February 3, 2019 13 min read

Continue reading

Part 5 of 10

SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function

March 24, 2017 14 min read

Continue reading

Part 6 of 10

SQL Server Performance Tuning Tips - What Is the Difference Between Seek Predicate and Predicate?

February 8, 2019 1 min read

Continue reading

Part 7 of 10

SQL Server - Using Calculated or Computed Columns for Performance Tuning

February 13, 2019 8 min read

Continue reading

Part 8 of 10

SQL Server - How to identify and collect information from slow queries using Extended Events (XE)

February 19, 2019 11 min read

Continue reading

Part 9 of 10

SQL Server - How to identify all missing indexes in a database

April 8, 2022 8 min read

Continue reading

Part 10 of 10

SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache

April 14, 2022 7 min read

Continue reading