Clear the Buffers in Database


DECLARE @intDBID INT; SET @intDBID = (SELECT [dbid] FROM master.dbo.sysdatabases WHERE name = 'AdventureWorks'); -- Flush the procedure cache for one database only
DBCC FLUSHPROCINDB (@intDBID); 
dbcc dropcleanbuffers 
dbcc freeproccache