Tag Archives: DBCC FREEPROCCACHE sql server 2008

Executing DBCC FREEPROCCACHE with parameters

DBCC FREEPROCCACHE, is used to clear all plan cache, which forces that every stored procedure will be recompiled  on it’s first execution to build a execution plan. This was known fact, till SQL Server 2005, DBCC FREEPROCCACHE has a server wide scope, means we can not clear a specific plan, this limitation was removed in [...]