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
(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
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker –
(Meeps, one of our seven cats, helping with the selection process…) Since my first round of community mentoring back in 2015, when I mentored 54
[Edit 12/16/2022:the deadline for submissions is now closed.] In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for
(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. :)