SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer | Journey to SQL Authority with Pinal Dave

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache would cause, for example, an ad-hoc SQL statement to be recompiled rather than reused from the cache. If observing through SQL Profiler, one can watch the Cache Remove events occur as DBCC FREEPROCCACHE goes to work. DBCC FREEPROCCACHE will invalidate all stored procedure… Continue Reading...

Source: SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer | Journey to SQL Authority with Pinal Dave