This stored procedure will allow you to easily disable and rebuild all indexes on a given table or set of tables (based on schema). It was designed for situations where a lot of data must be either added to or removed from tables, such as bulk inserts or purges of historical data. In certain cases, this can increase performance and reduce times for bulk operations. As with any piece of code, please test and evaluate thoroughly in a non production environment!

Download Here

Like this and what to hear about when I make updates or post new articles? Sign up for my mailing list to be notified.

Get My Free SQL-Tools Scripts

Put in your e-mail below and I'll send you a link to download a set of utilities I've made over the years. They've made my job easier and I know they will for you too!

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Powered by Optin Forms