The use of SQL Server table/index partitioning and data compression are supported configurations for on-premises installations of the [!INCLUDE[prod_short ...
INNER JOIN sys.indexes i ON t.[object_id] = i.[object_id] INNER JOIN sys.dm_db_index_usage_stats s WITH (NOLOCK) ON i.[object_id] = s.[object_id] AND i.index_id = s.index_id INNER JOIN sys.indexes i ...