Resetting Procedure Cache in SQL Server

17 Feb

Just a quick post but more for the fact that I don’t forget this in the future.  You might find that when optimising your sprocs, that they always run a lot quicker second time round due to caching. 

To reset the cache on each run of the SPROC just add these 2 lines to the top.  Remeber to remove these in production environments though



Leave a comment

Posted by on February 17, 2011 in SQL Server


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: