Monica Morehouse asks a question:
hile attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements that caught my attention. But there was one during the SQL keynote that made my DBA ears perk up: Automatic Index Compaction is generally available. And then came the comment that really got my attention: Could this be the beginning of the end of traditional index maintenance? Wait…WHAT? For those of us who have been working with SQL Server for a long time, index maintenance has practically been part of the DBA job description. Check fragmentation. Reorganize. Rebuild. Repeat. And for far too many environments, the strategy has basically been:
It’s Sunday at 2:00 AM. Time to rebuild ALL THE THINGS!
But should we really be doing that?
Click through for her answer. Also, shout out to Greg Moore in the comments for the Betteridge’s Law of Headlines usage. Greg is clearly a classy individual full of great ideas. Jeff Moden, additionally, has a comment worth reading.