<< Auto-formatting SQL Scripts | Gathering SQL Execution Statistics >>

Clearing Cached Query Plans

by Joe Havelick 27. January 2008 19:24

The following commands will clear any cached query plans in SQL 2005. This will allow you to better troubleshoot errors related to query plan generation.



DBCC DROPCLEANBUFFERS


DBCC FREEPROCCACHE

8c3f49cf-ccdc-40f2-b9a2-34dd6be858d6|0|.0|27604f05-86ad-47ef-9e05-950bb762570c

Tags: sql

Tech Tips

What's new in SQL 2008The following represents a summary of major features available with Microsoft SQL Server 2008 that w...Gathering SQL Execution StatisticsWhile troubleshooting SQL scripts that run inconsistently, it is often helpful to understand the tim...Five Hows and Barriers to Implementing ChangeEnvisioning change, whether it is in our personal or business plans, is often the first step to maki...

JoeHavelick.com

"Try to learn something about everything and everything about something." -Thomas H. Huxley

Clearing Cached Query Plans

Related posts

Add comment

About Me

Recommendations