Sometimes is useful to check how a certain query or a stored procedure behaves without cached data, so in this post I will show you how to reset SQL Server cache.

To do the job, simply run these statements from SQL Management Studio:

CHECKPOINT
GO

DBCC DROPCLEANBUFFERS
GO

DBCC FREEPROCCACHE
GO