Before I dropped an unused index, my client’s CEO wanted proof. Here is how to find queries using an index from the SQL Server plan cache.
SQL SERVER – 2017 – Script to Clear Procedure Cache at Database Level
I usually say no when customers ask to clear the cache. If you must, here is how to Clear Procedure Cache at database level in SQL Server 2017.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
Question: How to clear plan cache with Database Scoped Configuration? In SQL Server 2016 and later, one T-SQL command clears the plans for one database.
Heimdall Data Auto-Caching for SQL Server – No Changes to Application
Heimdall Data adds auto-caching and auto-invalidation to SQL Server with zero changes to your application or database. Here is how it works.
How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121
Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms
Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.