It’s almost a month since
my post on index maintenance based on fragmentation, in which I attempted
to show what can be done using simple script and some DMVs. There was some
discussion on LinkedIn group SQLDBA about it and I would refer to it with
The reason why I’m writing this is that I don’t want to be blamed for taking a proof
of concept (as my script was) and turning it into a primary maintenance solution.
As usual – read, test, ask questions, adapt, share your findings, we all will benefit
Tags: SQL Server, indexes, fragmentation,