Do you want it reorganized or do you want it performance tuned? The two things are vastly different.

Yes third party tools generally insert a backup row into the tables. The name of the backup will usually be some useless uniquifier. From my experience this includes vm snapshots...

I will do some more testing later today. As with Steve, I am just a touch busy to finish that off at the moment.

Well done. Congrats.

While it is a rather comprehensive list, there are some undocumented Trace Flags missing. Maybe a change in title would be appropriate? 😉

I was thinking of the stored procedure route. I really prefer partitioning because it is so much easier and it can take so much less time to run when done...

Can you provide sample output that you are seeing?

I disable windows defender on my SQL boxes. If you must have an AV on a database box, I want one that is highly configurable and reliable. The second part...

Let's keep it civil. It looks like we have two sides that might be getting a bit agitated.