SELECT st.name,
       CAST(ROUND(((SUM(au.total_pages)*8)/1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
       CAST(ROUND(((SUM(au.used_pages)*8)/1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
       sp.index_id,
       sp.data_compression
FROM sys.tables st
LEFT JOIN  sys.partitions sp on st.object_id = sp.object_id
INNER JOIN sys.allocation_units au ON sp.partition_id = au.container_id

group by st.name, sp.index_id, sp.data_compression
order by UsedSpaceMB desc

use DBName
GO  
exe sp_updatestats

alter index IndexName on TableName rebuild with (resumable = on, online = on)

SELECT
  t.Name                                          AS TableName,
  s.Name                                          AS SchemaName,
  p.Rows                                          AS RowCounts,
  SUM(a.total_pages)*8/1024                       AS TotalSpace_MB,
  SUM(a.used_pages)*8/1024                        AS UsedSpace_MB,
  (SUM(a.total_pages) - SUM(a.used_pages))*8/1028 AS UnusedSpace_MB,
  t.create_date,
  t.modify_date
FROM
  sys.tables t
  INNER JOIN sys.indexes i ON t.object_id = i.object_id
  INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id
  INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id
  LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE
  t.Name NOT LIKE 'dt%'
  AND t.is_ms_shipped = 0
  AND i.object_id > 255
GROUP BY
  t.Name, s.Name, p.Rows
ORDER BY
  TotalSpace_MB desc;
GO