SQL - Page Fragmentation

page-fragmentation.sql

SELECT a.index_id, name, avg_fragmentation_in_percent, fragment_count,
	avg_fragment_size_in_pages
FROM sys.dm_db_index_physical_stats(DB_ID('database'),
	OBJECT_ID('table'), NULL, NULL, NULL) AS a
JOIN sys.indexes AS b ON a.OBJECT_ID = b.OBJECT_ID AND a.index_id = b.index_id;