MSSQL Q&D Rowcount

select Distinct
object_name(id)
, rowcnt
from
sysindexes
where object_name(id) not like 'sys%'

Till Next Time