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.
Optimize for Ad Hoc Workloads: Shrinking a Bloated Plan Cache
One-off queries can fill your plan cache with plans nobody will reuse. Here is the setting that stores a stub instead, and how to check if you need it.
Why One Query Has Two Cached Plans: SET Options and plan_attributes
Investigate two cached plans with plan_attributes, decode differing SET options, and match application settings before diagnosing skew.