Fastest way to get rows count from large table (sql server database)


Query:

SELECT  Total_Rows= SUM(ss.row_count)
FROM   sys.dm_db_partition_stats ss
WHERE  object_name(object_id) = 'Table name' AND (index_id < 2)

No comments