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