SELECT object_name(id), rows

FROM sysindexes

WHERE INDID IN(0,1)

AND object_name(id) NOT LIKE 'sys%'

Gives all the tables and the rows in each table.

The below query gives the Table name(user table) and the rows in each:

This is faster because we are getting the data from sysindexes.

SELECT object_name(id), rows

FROM sysindexes

WHERE INDID IN (0,1)

AND...

Here are some differences:

...