Diagnose optimizer early termination in SQL Server plans, find cached timeouts with XML, and simplify queries using measured evidence.
SQL SERVER – Impact of Changing Database Compatibility Level on Cache
Changing the database compatibility level can clear plans from cache. Here is what happens to the query cache and why it matters.
Cold Cache vs Warm Cache: Testing Query Speed Fairly
Compare cold cache and warm cache query tests using isolated buffer clearing, logical and physical reads, and controlled measurements.
Prepared Statements and Plan Reuse From Application Code
Inspect prepared statements, handle lifetimes, parameter types, cached Prepared plans, and the limits of optimize for ad hoc workloads.
Cached Plan Reuse: How to Tell if a Query Used a Cached Plan
Cached plan reuse is invisible in a result set. This post shows three checks on SQL Server: the compiled and runtime parameter values in the plan, the usecounts column of the plan cache, and the plan creation time.
Flush Authentication Cache: Who Can Run DBCC FLUSHAUTHCACHE
Flush authentication cache entries with DBCC FLUSHAUTHCACHE. This post tests the command on SQL Server 2025, shows who can run it and that on SQL Server 2025 it ends no open session, and says what it is documented to do on Azure SQL Database.
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.