Query Optimization

Beneficial SQL Server Query Optimization tips, tutorials, how-to’s, scripts, and more for SQL Server Developers.

Title Author Date
SQL Query Optimization with SQLGrease Jeremy Kadlec2026-02-05
SQL Case Sensitive Search on a Case Insensitive SQL Server Jeremy Kadlec2025-05-21
Tuning Problematic SQL Server Queries with Minimal Changes MSSQL Tips2023-11-30
SQL Server Query Performance Degradation Over Time Aaron Bertrand2023-10-10
Faster Transactions: SQL Server Query Tuning Techniques MSSQL Tips2023-04-13
Tune and Optimize SQL Server Queries Eduardo Pivaral2022-02-23
Query Tuning in SQL Server with Set Statistics IO Rick Dobson2020-05-25
Crosstab queries using PIVOT in SQL Server Greg Robidoux2019-03-22
Parallelism in SQL Server Execution Plan Ahmad Yaseen2018-03-30
SQL Server 2014 Incremental Update Statistics Per Partition Ahmad Yaseen2017-05-05
Different Approaches to Correct SQL Server Parameter Sniffing Daniel Farina2014-06-24
How to Change the COLLATION of a SQL Server Column Ben Snaidero2014-05-02
How column COLLATION can affect SQL Server query performance Ben Snaidero2014-04-24
Are Your SQL Server Application Queries Wasting Memory MSSQL Tips2008-11-21
Lengthy SQL Server Queries Will Consume Your CPU Tal Olier2008-05-16
Specifying Max Degree of Parallelism in SQL Server for a Query Jeremy Kadlec2006-08-24
Using Derived Tables to Simplify the SQL Server Query Process Greg Robidoux2006-08-16