SELECT object_name(ps.object_id) AS [name], 
	ps.index_id,
	i.name AS IndexName,
	ps.avg_fragmentation_in_percent, 
	ps.fragment_count,
	ps.avg_fragment_size_in_pages, 
	ps.page_count 
FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL) ps
LEFT JOIN sys.indexes i ON i.object_id=ps.object_id AND i.index_id=ps.index_id
WHERE ps.avg_fragmentation_in_percent > 10
AND ps.page_count  > 100
ORDER BY ps.avg_fragmentation_in_percent DESC

select object_name(ps.object_id) as [name], ps.index_id, i.name as IndexName, ps.avg_fragmentation_in_percent, ps.fragment_count, ps.avg_fragment_size_in_pages, ps.page_count from sys.dm_db_index_physical_stats(DB_ID(),null,null,null,null) ps left join sys.indexes i on i.object_id=ps.object_id and i.index_id=ps.index_id where ps.avg_fragmentation_in_percent > 10 and ps.page_count > 100 order by ps.avg_fragmentation_in_percent desc