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 part from SQL Server DateTime datatype
How to use SQL RAISEERROR() messages in C#
Create, Alter, Drop and Execute SQL Server Stored Procedures
Get the First and Last Word from a String or Sentence in SQL
How to hide letters with asterisks except first letter in SQL
Post Views: 32

Leave a Reply

Your email address will not be published.

Most Viewed Posts