SQL Server: Recompiling objects after cleaning plan cache with FMTONLY

1 Kicks

submitted by spirit1(3160) 4 years, 6 months ago

a script that can be used to automate database object recompiling with the use of a not well known SET FMTONLY ON option.

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Comments:

No comments so far

What's this?