select schema_name(t.schema_id) as [Schema], t.name as TableName,i.rows as [RowCount] 
from sys.tables as t, sys.sysindexes as i
where t.object_id = i.id and i.indid <=1
order by rows desc;