Determining Table sizes (in KB)

Ever wanted to find out the amount of space a table
is taking up (in Kilobytes, not record size... although
you will be able to get the record size too this way).

Microsoft has a very convoluted method of doing this
(a 10 step process that can be found in the latest
"SQL Books online", go to the index and look under the
heading "tables-SQL Server" and then "calculating size",
then choose "Estimating the Size of a Table"). Which
I guess, if you dont have access to Enterprise Manager
you would have to do this.

But, if you do have Enterprise Manager, just select
your Database in the left-hand pane. Then goto the
View menu (in the Console Root, not in the MMC main
window, where you sometimes get a View menu)...

Choose "Taskpad", then go to the "Table Info" tab in
the right-hand pane, and you will be presented with
the number of records, as well as Total table size and
the size for each index associated with a table, all in
Kilobytes.

Hope this helps someone (sure beats the method I was
going to have to try to get the same info).

Tj

12/7/04: User, Kaz999 pointed out an easy way to get this kind of information via TSQL...


...gives you...