for the reccount in all tables of a database, I use that view:

CREATE VIEW [dbo].[v_reccount]  AS 
SELECT        o.name                 AS NomTable ,
              ddps.row_count         AS Reccount
       FROM   sys.indexes            AS i
              INNER JOIN sys.objects AS o
              ON     i.object_id = o.object_id
              INNER JOIN sys.dm_db_partition_stats AS ddps
              ON     i.object_id = ddps.object_id
                 AND i.index_id  = ddps.index_id
       WHERE (
                     i.index_id < 2
              )
          AND (
                     o.is_ms_shipped = 0
              )

It relies on statistics, so you need to set the stats auto