Extremly Fast Way For Table Row Counts Sql Server Database

This SQL Server query gives the row count for each user table using sys.dm_db_partition_stats.

SELECT 
SCHEMA_NAME(o.schema_id) as schemaname
,o.name
,ddps.row_count
FROM sys.indexes AS i
  INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID
  INNER JOIN sys.dm_db_partition_stats AS ddps ON i.OBJECT_ID = ddps.OBJECT_ID
  AND i.index_id = ddps.index_id 
WHERE i.index_id < 2  AND o.is_ms_shipped = 0 
ORDER BY ddps.row_count desc