Need to check row count of each table in the database in an efficient manner? Here is the query that you can simply copy and execute in your database. This would give you instant results irrespective of how heavy your tables are –
SELECT
DB_NAME() "Database Name"
, t.schema_id "Schema ID"
, t.object_id "Object ID"
, OBJECT_SCHEMA_NAME(t.object_id) "Schema Name"
, OBJECT_NAME(t.object_id) "Table Name"
, SUM(p.rows) "Rows Count"
FROM sys.tables t
INNER JOIN sys.partitions p
ON t.object_id = p.object_id
INNER JOIN sys.indexes i
ON p.object_id = i.object_id
AND p.index_id = i.index_id
WHERE i.index_id < 2
GROUP BY t.schema_id
, t.object_id
ORDER BY 6 DESC
Enjoy!