Ways of Retrieving Table Row Count without using Count function.

select convert(bigint,rows) as Row_Count
from sysindexes
where id = object_id('Test1')
and indid < 2;

select sum(row_count) as Row_Count 
from sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('Test1')
AND (index_id in(0,1));