SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache April 14, 2022 7 min read Continue reading
SQL Server is extremely fast. You just do not know how to use it! April 28, 2021 1 min read Continue reading
SQL Server - Using Calculated or Computed Columns for Performance Tuning February 13, 2019 8 min read Continue reading
SQL Server - How to identify a slow or "heavy" query in your database July 8, 2018 26 min read Continue reading
SQL Server - Introduction to Performance Tuning Study September 30, 2017 16 min read Continue reading
SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function March 24, 2017 14 min read Continue reading
SQL Server - The Danger of Using JOIN Between Columns of Different Data Types April 29, 2016 2 min read Continue reading
