I'm about to start a new series of post about index fragmentation and removing it. For this week's survey, I'd like to know what index maintenance you do to address fragmentation (in any of its forms) – I'll report on it in a week.
Thanks
Ten years ago today we announced that we were hiring our first employee: Jonathan Kehayias. It was a big risk for Kimberly and I, as
(This is also the Ponderings – editorial – in today’s SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes
Over the last year, after we were forced to move our Immersion Events online, we’ve realized the power and flexibility of online training and we
Our classes are all open for registration and we have deep discounts running through the end of the month! Once again they will all be online,
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
One thought on “Weekly survey: index maintenance plan”
Interesting question! I answered "Complex maintenance based on a list of indexes, fragmentation, or other factors." If you’re interested, the script I use can be found here: http://sqlfool.com/2009/03/automated-index-defrag-script/. If you’ve got time and any inclination, I’d love to hear your thoughts on it, especially if I’m missing anything. :)