Leave a Reply

One comment

  1. Good solution . Is there some missing in below sql
    — Example 3 (Scalpel)
    — Remove one plan from the cache
    — Get the plan handle for a cached plan
    SELECT cp.plan_handle, st.
    FROM sys.dm_exec_cached_plans AS cp
    CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st
    WHERE LIKE N’%/* GetOnlineSearchResultsMonday %’;

    subhash Lahoti Reply