 
           Then '
 
-                ALTER INDEX [<idx>] ON [<DbName>].[<scn>].[<tb>] 
-
-                Rebuild with (fillfactor = 90)
+                ALTER INDEX [<idx>] ON [<DbName>].[<scn>].[<tb>] Rebuild;
 
                 '
 


    , PS.alloc_unit_type_desc 

    , Max (partition_number) OVER(PARTITION BY IDX.object_id, IDX.index_id) as TotPartNb

    , (

      select top 1 SC.name from sys.columns SC 


   

End -- Mirroring.Failover

go

