Returns fragmentation in percentage average for the indexes of a SQL Server database.

gistfile1.sql

SELECT
	OBJECT_NAME(F.object_id) AS [table], 
	index_type_desc, 
	avg_fragmentation_in_percent,
	ISNULL(name,'heap') AS [index]
FROM 
	sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS F
INNER JOIN 
	sys.indexes AS I ON F.object_id = I.object_id AND F.index_id = I.index_id
ORDER BY 
	avg_fragmentation_in_percent DESC