-- Do not lock anything, and do not get held up by any locks. 
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 

-- Quickly get row counts.
SELECT  OBJECT_SCHEMA_NAME(p.object_id) AS [Schema]
		, OBJECT_NAME(p.object_id) AS [Table]
		, i.name AS [Index]
		, p.partition_number
		, p.rows AS [Row Count]
		, i.type_desc AS [Index Type]
FROM sys.partitions p 
INNER JOIN sys.indexes i ON p.object_id = i.object_id
						AND p.index_id = i.index_id
WHERE OBJECT_SCHEMA_NAME(p.object_id) != 'sys'
ORDER BY [Schema], [Table], [Index]
