My favorite is the one that Reorganises, then rebuilds the indexes, then does a DB shrink on all the sys databases
I believe that one is known as 'complete waste of time'
The rebuild redoes everything the reorg has already done, then the shrink undoes what the rebuild did. Deleting the entire maint plan would probably result in better maintained indexes.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass