Tag Archives: How to clear a sql_handle? How to get clear a cache using a sql handle

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 [...]