FlashVols are volumes that are pinned in SSD so applications run at maximum performance without the potential delay due to caching algorithms or tiering policies. Combined with Tegile's de-duplication ...
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 ...