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

Tags:

Tech Tips

Comments are closed

About Me

Joe Havelick is a reasonable facsimile of this photo.


profile for Joe on Stack Exchange, a network of free, community-driven Q&A sites

Recommendations