Wait Statistics and Query Store Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database. Erin Stellato ◆ November 27, 2017 3
Using DBCC CLONEDATABASE and Query Store for Testing Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes. Erin Stellato ◆ February 22, 2017 6
The SQL Server Query Store Benjamin Nevarez (@BenjaminNevarez) gives a very early look at a feature coming soon to Azure SQL Database and SQL Server vNext: the Query Store. Guest Posts ◆ February 19, 2015 10
Dealing With Explosive sysjobhistory Growth Aaron Bertrand explains how he fixed a vendor query against sysjobhistory with memory grants so large that SQL Server would shut itself down. Aaron Bertrand ◆ June 24, 2026 0
Simple Parameterization and Trivial Plans — Part 3 Paul White continues his series on simple parameterization and trivial plans with a look at the information available in execution plans. Paul White ◆ April 18, 2022 2
Refreshing SQL Server Tables With Less Interruption Using Partition Switching Aaron Bertrand talks about using partition switching to load refreshed SQL Server tables without impacting current users. Aaron Bertrand ◆ September 29, 2021 3
Updated Azure SQL Database Tier Options Tim Radney explains many new options for Azure SQL Database, including serverless, hyperscale, and hardware configuration optimized for CPU or memory. Tim Radney ◆ April 27, 2020 0
Bandwidth-friendly Query Profiling for Azure SQL Database This script to update the default extended events session for ADS Profiler will make for a safer and more bandwidth-friendly query capture experience for Azure SQL Database. Greg Gonzalez ◆ April 15, 2020 0
An approach to index tuning – Part 2 Erin Stellato concludes her two-part series on her multi-step approach to index tuning in SQL Server. Erin Stellato ◆ April 13, 2020 1
An approach to index tuning – Part 1 Erin Stellato walks through her multi-step approach to index tuning, with thorough explanations and simple but clever visualizations. Erin Stellato ◆ March 26, 2020 8
Why Wait Stats Alone Are Not Enough Tuning SQL Server by looking at waits alone and ignoring resources could be costing you time, money, and performance. Greg Gonzalez explains why. Greg Gonzalez ◆ January 24, 2020 5
