Add Index rebuild command into alert mail
I get sometimes Fragmented Index alerts as mail.
To fix it , I have to copy every single index name into the clipboard, switch to SSMS, write “ALTER INDEX ”, insert the index name and let SQL Prompt add the AS <table> and finally have to add the word REBUILD.
Why do you not make it simpler for me (and other customers) and add just another column that already contains the whole INDEX REBUILD command (or REORGANIZE if the fragmentation is low) to the mail / web frontent.
It's still to me, if I want to execute it or if I just rerun my regular index maintenance etc.
Since it is just a simple string concation with existing data, it should be done by your devs in maybe 30 minutes.