Fastest way to count rows in a MASSIVE table MSSQL

SELECT
Total_Rows= SUM(st.row_count)
FROM
sys.dm_db_partition_stats st
WHERE
object_name(object_id) = 'TABLENAME' AND (index_id < 2)

Jeremy Tirrell

Read more posts by this author.