ALTER TABLE TableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
и ее индексы:
ALTER INDEX IndexName ON Table REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)

use BDName
Go
declare @DbId smallint = DB_ID('BDName')

declare @IndexTmpTable table (Id INT IDENTITY(1,1) primary key,
                              SchemaName SYSNAME, 
                              TableName SYSNAME, 
                              IndexName SYSNAME, 
                              PageCount INT,
                              AvgFrag FLOAT)

declare @RowNumber INT = 1, @CntRows INT, @CntReorganize INT = 0, @CntRebuild INT = 0
declare @SchemaName SYSNAME, @TableName SYSNAME, @IndexName SYSNAME, @AvgFrag FLOAT
declare @Command VARCHAR(8000)
declare @FileName VARCHAR(100) = 'stop_defrag.txt'

declare @profile_name as nvarchar(100) = 'profile'
declare @recipients as nvarchar(500) = 'address@domen.ru'
declare @subject as NVARCHAR(100) = ''
declare @massage as NVARCHAR(1000) = ''

begin;
    
insert into @IndexTmpTable
                select Sch.name as SchemaName, 
                           Obj.name as TableName,
                           Inx.name as IndexName,
                           Page_count as  Pagecount,
                           round(AvgFrag.avg_fragmentation_in_percent,0) as Fragmentation 
                from sys.dm_db_index_physical_stats (@DbId, NULL, NULL, NULL, NULL) as AvgFrag
                LEFT JOIN sys.indexes as Inx on AvgFrag.object_id = Inx.object_id AND AvgFrag.index_id = Inx.index_id
                LEFT JOIN sys.objects as Obj on AvgFrag.object_id = Obj.object_id 
                LEFT JOIN sys.schemas as Sch on Obj.schema_id = Sch.schema_id
                where AvgFrag.index_id > 0 AND AvgFrag.avg_fragmentation_in_percent > 5 AND AvgFrag.page_count > 8
                order by Pagecount desc

select @CntRows = COUNT(*)
from @IndexTmpTable

while @RowNumber <= @CntRows
 begin

  --Получаем названия объектов, а также степень фрагментации текущего индекса
  select @SchemaName = SchemaName, @TableName = TableName, @IndexName = IndexName, @AvgFrag = AvgFrag
  from @IndexTmpTable
  where Id = @RowNumber

  --Если текущее время больше заданного, прекращаем дефрагментацию
  if @@FETCH_STATUS < 0 OR (datepart(hour, GETDATE()) >= 8 AND datepart(minute, GETDATE()) >= 0) 
   begin
    --Запись индекса на котором остановилась дефрагментация для информирования в сообщении
    set @command='echo ' + @TableName + '.' + @IndexName + ' > ' + @FileName
    exec master..xp_cmdshell @command
    
   --Отправка email
    set @subject = @profile_name + ': Стоп дефрагментации по времени'
    set @massage ='Стоп дефрагментации по времени на индексе ' + @TableName + '.' + @IndexName + CHAR(10) + CHAR(13) +
	              'Дефрагментировано ' + CAST(@RowNumber AS VARCHAR(100)) + ' из ' + CAST(@CntRows as VARCHAR(100)) + ' индексов'
    exec msdb.dbo.sp_send_dbmail
    	@profile_name = @profile_name,
    	@recipients = @recipients,
    	@body = @massage,
    	@subject = @subject;
    
    BREAK
   end;
                        
  if @AvgFrag < 30
   begin
    select @Command = 'ALTER INDEX [' + @IndexName + '] ON ' + '[' + @SchemaName + ']' 
                               + '.[' + @TableName + '] REORGANIZE';
    exec (@Command);
    set @CntReorganize = @CntReorganize + 1;
   end 
                        
  if @AvgFrag >= 30
   begin
    select @Command = 'ALTER INDEX [' + @IndexName + '] ON ' + '[' + @SchemaName + ']' 
                               + '.[' + @TableName + '] REBUILD';
    exec (@Command);
    set @CntRebuild = @CntRebuild + 1;
   end
                        
  print 'Выполнена инструкция ' + @Command;
  set @RowNumber = @RowNumber + 1
 end

end;