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
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed