Thanks for the response, Jeffrey. If you go to the first article I provided a link for and then search for "A/B", that 3 character link will take you to the second link I cited, which is the Query Store A/B testing I spoke of.
I also see what you're talking about with the recommendation that REORGANIZE is the preferred thing... which is totally incorrect in all but a couple of special cases (and, yeah, I prove that in my presentations on the subject).
You DID come to the same conclusion as I...
Jeffrey Williams wrote:
I guess this means we are back to looking at each table/index and determining the best strategy for index maintenance for each one - based on the usage patterns and the structure of that index. This is going to require DBA's to review their systems and determine how they are being used - modify the clustered index - set an appropriate fill factor - and schedule the index maintenance.
I actually have code that does most of that. I'm still tweaking it and so haven't released it, yet.
As for using Ola's Code... his code is nothing short of remarkable but, if people are using it to run the old 5/30 supposed "Best Practices" that were never meant to be a "Best Practice" and are actually a worst practice, then they have some serious problems. Again, with only a couple of exceptions, using REORGANIZE in regular index maintenance is a form of "Death by Defragmentation" and based on the amount of Log File that REORGANIZE actually does use compared to Rebuilds, I'm not likely to use it except for one of those exceptions because nothing else will compact LOBs short dropping the table and rebuilding it from the data.
So, the good part is they've removed the 5/30 junk from the article. That bad part is that they've provided nothing reasonable for the bulk handling of index maintenance and they've perpetuated the myth of REORGANIZE somehow being friendly when it's actually one of the worst things you can do to most indexes.
That means the 5/30 thing will still prevail because newbies will ask for what to do and, since the whole freakin' world has been making the same mistake for more than 2 decades, they'll continue to recommend that same poor practice.
Looks like I need to redouble my efforts on getting a Stairway on the subject out.
Again... thanks for the reply, Jeffrey.