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 - How to identify all missing indexes in a database April 8, 2022 8 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 - Useful Day-to-Day DBA Queries You Always Have to Search for Online July 15, 2019 73 min read Continue reading
SQL Server - When You Should Use ORDER BY in Queries and When You Should Never Use It February 24, 2019 5 min read Continue reading
SQL Server - How to identify and collect information from slow queries using Extended Events (XE) February 19, 2019 11 min read Continue reading
SQL Server - Using Calculated or Computed Columns for Performance Tuning February 13, 2019 8 min read Continue reading
SQL Server Performance Tuning Tips - What Is the Difference Between Seek Predicate and Predicate? February 8, 2019 1 min read Continue reading
SQL Server Performance Tuning Tips - Implicit Conversion: Never Again February 3, 2019 13 min read Continue reading
SQL Server - How to identify the queries that use a specific index through the plan cache December 9, 2018 5 min read Continue reading
SQL Server 2019 - Understanding the row estimation changes for table variables October 7, 2018 1 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 2017 - How to pause an index rebuild using Resumable Online Index Rebuilds February 14, 2018 7 min read Continue reading
SQL Server - How to improve formatting of combined query output with SET STATISTICS IO and TIME January 21, 2018 3 min read Continue reading
SQL Server - How to practically share your execution plans on the Web October 20, 2017 3 min read Continue reading
SQL Server - Introduction to Performance Tuning Study September 30, 2017 16 min read Continue reading
SQL Server - How to identify and collect information from slow queries using Trace (SQL Server Profiler) September 30, 2017 5 min read Continue reading
SQL Server - How to generate deadlock history monitoring for routine failure analysis September 30, 2017 12 min read Continue reading
SQL Server - Query to Return Active Sessions with sp_WhoIsActive Without Consuming TempDB July 25, 2017 13 min read Continue reading
SQL Server - How to calculate the difference in years (age) between two dates using T-SQL or CLR April 9, 2017 4 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 - Using the SQLQueryStress Tool to Optimize Your SQL Queries December 25, 2016 4 min read Continue reading
SQL Server - Using sp_WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries and Much More June 26, 2016 15 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