run: DBCC UPDATEUSAGE('northwind') WITH COUNT_ROWS



>>I just saw the thread posed about getting the sizes of all the tables in a database. I thought the code could be improved by eliminating the cursor and temp table. I posted it on the sqlteam forum, feel free to snatch it.
>>
>>http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31999
>
>Hi Eric,
>
>Below is result of running your code against NorthWind DB. As you can see, tables witn non-clustered indexes have two lines in result.
>
>

id          name                 rowcnt   reserved    data        indexp      unused
>----------- -------------------- -------- ----------- ----------- ----------- -----------
>21575115    Orders               0        504         160         320         24
>21575115    Orders               830      504         160         320         24
>325576198   Order Details        0        328         72          208         48
>325576198   Order Details        2155     328         72          208         48
>1977058079  Employees            0        320         232         48          40
>1977058079  Employees            9        320         232         48          40
>2041058307  Categories           0        176         112         32          32
>2041058307  Categories           8        176         112         32          32
>2073058421  Customers            0        104         24          80          0
>2073058421  Customers            91       104         24          80          0
>117575457   Products             0        104         8           96          0
>117575457   Products             77       104         8           96          0
>2137058649  Suppliers            0        72          24          48          0
>2137058649  Suppliers            29       72          24          48          0
>1093578934  dtproperties         7        64          48          16          0
>885578193   Region               4        32          8           24          0
>901578250   Territories          53       32          8           24          0
>917578307   EmployeeTerritories  49       32          8           24          0
>2105058535  Shippers             3        24          8           16          0
>
>(19 row(s) affected)
>
>