Clear entire procedure and databuffer cacheCheckpoint --> Write dirty pages to diskDBCC FreeProcCache --> Clear entire proc cacheDBCC DropCleanBuffers --> Clear entire data cacheClear only a particular db procedure cache using undocumented DBCC commandDeclare @DBID intSelect @DBID =db_id(‘YourDBname’)DBCC FLUSHPROCINDB(@DBID) – Undocumented dbcc command to clear only a db proc cache  
Leggi tutto il post...