SQL

How to clean Query and Execution Plan Cache for Efficient Testing in MS SQL

- 11.04.20 - ErcanOPAK 
CHECKPOINT
GO
--Cleaen Query Cache
DBCC DROPCLEANBUFFERS;
GO
--Clean Execution Plan Cache
DBCC FREEPROCCACHE;
GO

Related posts:

How to solve “A cursor with the name already exists” problem?
Drag and Drop objects from Object Explorer to the Query Window in SQL Server
Average of all values in a column that are not zero in SQL
Search text in all stored procedures in SQL Server
Database stuck in “Restoring” state
Post Views: 31

Leave a Reply

Your email address will not be published. Required fields are marked *

Most Viewed Posts