September 25, 2007 at 12:12 pm
Comments posted to this topic are about the item Row count of all tables
October 5, 2007 at 10:01 am
The following query also gives the same results without creating a table.
TableName = object_name(id),
[RowCount] = max(rows)
group by id
October 5, 2007 at 10:13 am
This works only if the stats are up to table. It's ok if an estimate is all you need. However if you need accuracy, you need to use count(*).
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply