
GOTCHA: SQL Server changes query plan without changing plan_handle
Or how to efficiently get at old query plans Performance Tuning Mission While on a SQL Server 2008 Data Warehouse performance tuning mission, this aspect (or undocumented gotcha as it felt like at the time) of the query plan Dynamic Management Functions caused some head scratching, until I sussed that: A query plan can change […]