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:

Change Default Value for "Select Top n" and "Edit Top n" Rows in SQL Server Studio
sp_help for SQL Server Management Studio
How to check for 'IS NOT NULL' And 'IS NOT EMPTY' string in SQL
Add Default Value in SQL Server
Add Constraint to SQL Table to ensure email contains @
Post Views: 31

Leave a Reply

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

Most Viewed Posts