Stackify_Blog_Post_Snip_ViewPartitions.sql

SELECT o.name objectname,i.name indexname, partition_id, partition_number, [rows]
FROM sys.partitions p
INNER JOIN sys.objects o ON o.object_id=p.object_id
INNER JOIN sys.indexes i ON i.object_id=p.object_id and p.index_id=i.index_id
WHERE 
	o.name LIKE '%Imagination%'
	AND [rows] > 0
ORDER BY o.name, i.name DESC, partition_number DESC