SQL Query to find row Count of Tables in a Database

Row Count of Tables in DB:

SELECT    Row_Number() Over (Order by tbl.name) As SNo
        ,[TableName]=tbl.name
        ,[RowCount] = SUM(CASE WHEN (pt.index_id < 2)
        AND (au.type = 1) THEN pt.rows ELSE 0 END)
FROM sys.tables tbl
INNER JOIN sys.partitions pt ON tbl.object_id = pt.object_id
INNER JOIN sys.allocation_units au ON pt.partition_id = au.container_id
GROUP BY tbl.name

Total Row Count in DB, useful for ETL Testing:

Select    Sum(TEMPTABLE.[RowCount]) As [Total] from sys.Tables tb2
LEFT jOIN (SELECT    Row_Number() Over (Order by tbl.name) As SNo
        ,[TableName]=tbl.name
        ,[RowCount] = SUM(CASE WHEN (pt.index_id < 2)
        AND (au.type = 1) THEN pt.rows ELSE 0 END)
FROM sys.tables tbl
INNER JOIN sys.partitions pt ON tbl.object_id = pt.object_id
INNER JOIN sys.allocation_units au ON pt.partition_id = au.container_id
GROUP BY tbl.name) TEMPTABLE ON TEMPTABLE.Tablename = tb2.name

Thanks
Mahadevan