Быстро получить select count(*) from table

SQL Server–HOW-TO: quickly retrieve accurate row count for table

SELECT SUM (row_count)
FROM sys.dm_db_partition_stats
WHEREobject_id=OBJECT_ID('Transactions')
AND (index_id=0 or index_id=1);