SQL Server: DBCC to Clean Cache and Clean Buffer for Stored Procedure

Why do we require to clear the cache and buffer before executing a stored procedure in SQL Server? Sometimes it needs to clear buffer and cache for measuring the exact time duration between the executions. SQL Server provides two DBCC commands to clear the cache and buffer. DBCC FREEPROCCACHE : You can use above DBCC … Continue reading SQL Server: DBCC to Clean Cache and Clean Buffer for Stored Procedure