I agree. I too am curious under what circumstances it would be useful to know the row-count from all tables.

Also under what circumstances is it useful to use 6 or 7 lines of query versus a single SELECT statement.

As a peek into the guts of the SQL Server system and thinking behind it, this is fascinating, but seems it would rarely be of use.