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!
Like this and what to hear about when I make updates or post new articles? Sign up for my mailing list to be notified.