How to clean Query and Execution Plan Cache for Efficient Testing in MS SQL – Bits of .NET

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:

SQL Server: Querying JSON Columns Like a Pro

How to solve “A cursor with the name already exists” problem?

How to add default value for Entity Framework migrations for DateTime and Bool

Post Views: 40

Leave a Reply Cancel reply