DB table & row count

SELECT

T.name,

I.rows

FROM

sys.tables AS T 

INNER JOIN

sys.sysindexes AS I ON T.object_id = I.id

AND I.indid = 0

ORDER  BY

I.rows DESC