ritacse
12/31/2017 - 11:24 AM

Cache Clear in SQL

/*Removes all elements from the plan cache, removes a specific plan from 
the plan cache by specifying a plan handle or SQL handle, 
or removes all cache entries associated with a specified resource pool.*/

EXEC DBCC FREEPROCCACHE