>>Check my blog post
>>
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-get-information-about-all-databas>>
>>I believe I do have this script there (may be even a few).
>
>I executed the one "Record Count in every table in a database". It is very slow. I am better off just to scan all my tables one by one and execute the other script which provides instant result. Is that the script you were referring to?
>
>However, when I executed "Sizes of All Tables in a Database", that one gives an instant result and provides all the fields as the script I initially provided. That one seems to be the good one to use.
There are a few record counts there also. One which is based on count(*) from each table is going to be slow (but not that slow). There are scripts based on sys.partitions table if I recall, they should be much faster.
The Sizes of All Tables in a Database is the one you need, I believe.
If it's not broken, fix it until it is.
My Blog