Clear sql buffer and cache / The Lazy Developer

DBCC FREESYSTEMCACHE ('userdatabase') -- cleans cache for specific user database
DBCC FREESYSTEMCACHE ('tempdb')  -- clears cache for tempdb
DBCC FREESYSTEMCACHE ('Temporary Tables & Table Variables')
Go
DBCC FLUSHPROCINDB (8) -- 8 is the databaseid of Dec_ProdStats
GO
-- Clean all the caches with entries specific to the resource pool named "default".  
DBCC FREESYSTEMCACHE ('ALL', default);

--MARK_IN_USE_FOR_REMOVAL clause to release entries from all current caches once the entries become unused.
DBCC FREESYSTEMCACHE ('ALL') WITH MARK_IN_USE_FOR_REMOVAL;  

--Suppresses all informational messages.
DBCC FREEPROCCACHE with NO_INFOMSGS

DBCC DROPCLEANBUFFERS --clears clean (unmodified) pages from the buffer pool
Precede that with a CHECKPOINT to flush any dirty pages to disk first
DBCC FLUSHPROCINDB --clears execution plans for that database

DBCC FREESYSTEMCACHE ('userdatabase') -- cleans cache for specific user database

DBCC FREESYSTEMCACHE ('tempdb') -- clears cache for tempdb

DBCC FREESYSTEMCACHE ('Temporary Tables & Table Variables')

DBCC FLUSHPROCINDB (8) -- 8 is the databaseid of Dec_ProdStats

-- Clean all the caches with entries specific to the resource pool named "default".

DBCC FREESYSTEMCACHE ('ALL', default);

--MARK_IN_USE_FOR_REMOVAL clause to release entries from all current caches once the entries become unused.

DBCC FREESYSTEMCACHE ('ALL') WITH MARK_IN_USE_FOR_REMOVAL;

--Suppresses all informational messages.

DBCC FREEPROCCACHE with NO_INFOMSGS

DBCC DROPCLEANBUFFERS --clears clean (unmodified) pages from the buffer pool

Precede that with a CHECKPOINT to flush any dirty pages to disk first

DBCC FLUSHPROCINDB --clears execution plans for that database