Compare SEQUENCE cache size, restart gaps, rollback gaps, and insert throughput with CACHE 50, CACHE 1000, and NO CACHE.
DMV Snapshot Deltas for a Query Activity Interval
DMV snapshot deltas show counter growth for cached statements that survive two observations. Compare their identities and report missing coverage before ranking activity.
Sequence Gaps: Why NEXT VALUE FOR Skips Numbers
Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.
Report Caching and Snapshots in SSRS
Report caching and snapshots in SSRS reduce repeated database work when freshness rules, parameter combinations, and schedules are clear.
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
Why does a stored procedure take longer the first time? Stored procedures are not pre-compiled; each one is compiled on first run and cached after that.
SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.
Finding Single-Use Plans Wasting Memory in the Cache
Find single-use plans, compare their cache memory with the total, and inspect parameterization before discussing server-wide cache settings.