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 return only the Date from a SQL Server DateTime datatype
View the Definition of a Stored Procedure in SQL
Get the User Name and Domain Name from an Email Address in SQL
How to create Local and Global Temp Tables in MS SQL
Date and Time Conversions in SQL Server
Post Views: 31

Leave a Reply

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

Most Viewed Posts