CONVERT(DECIMAL(8,2), i.dpages / 128.0) AS MBUsed

SELECT	LEFT(OBJECT_NAME (i.id), 50)	AS TableName,
	LEFT(ISNULL(i.name,'HEAP'), 50)	AS IndexName,
	CASE WHEN u.object_id IS NULL THEN 'No Data' ELSE 'No Usage' END AS Determination,
	i.dpages	AS PagesUsed,
	CONVERT(DECIMAL(8,2), i.dpages / 128.0) AS MBUsed
FROM		sys.objects o
	JOIN	sys.sysindexes i
	ON	i.id = o.object_id
	LEFT JOIN sys.dm_db_index_usage_stats u
	ON		i.indid = u.index_id
		AND	u.object_id = i.id
WHERE		o.type = 'U'			-- Exclude system tables.
	AND	i.name IS NOT NULL		-- Exclude heaps
	AND	i.name NOT LIKE '_WA_Sys%'	-- Exclude statistics
	AND	(	u.object_id IS NULL	-- Either no usage stats, or...
		OR	(	u.user_seeks = 0	-- all usage stats are zero.
			AND	u.user_scans = 0
			AND	u.user_lookups = 0
			)
		)
ORDER BY i.dpages DESC