-- FIND THE AVERAGE FRAGMENTATION PERCENTAGE OF ALL INDEXES.
SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(N'B8R3_YSNT_QT_DATA'), OBJECT_ID(N''), NULL, NULL, NULL) AS a
JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id
WHERE a.index_id <> 0;