SELECT SO.name, SP.rows FROM sys.objects SO JOIN sys.partitions SP ON SO.object_id = SP.object_id WHERE SO.type = 'U' AND SP.index_id < 2 ORDER BY SP.rows DESC;