Fastest way to get rows count from large table (sql server database) February 01, 2019 Query: SELECT Total_Rows= SUM(ss.row_count) FROM sys.dm_db_partition_stats ss WHERE object_name(object_id) = ' Table name...Read More