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.
SQL SERVER – Is Query from Cache? Execution Plan Property
Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE
A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to 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.