yochananrachamim / AzureSQL

132 stars 61 forks source link

AzureSQLMaintenance.txt horizontal partitioning support #23

Closed marmiskeje closed 1 year ago

marmiskeje commented 3 years ago

Hi!

Thank you for script "AzureSQLMaintenance.txt". It´s very nice. But... it looks like that it doesn´t handle situation when there is horizontal partitioning on table. So it reports many indices and rebuild itself will try to rebuild one index and all it´s partitions multiple times. It would be great if there was only one rebuild. Rebuild by partition is not so important, I think...

Best regards!