Table size count

Anand

Hi all

Please help me to find out table size in MS-SQL

how can I count or identify, this specific table is using some xyz kb
of space of my hdd.

thanks

Jul 20 '05 #1

Don

you want to know the size of one Table from a database !! not the size
of the database size on your HD ??!

your database will take a size bigger than what all tables are using
and then it will grow in a % as needed !
so the size that the database is always bigger than the actual total
use of all tables in a database.

anyways, the number of rows in a table * sum of bits in table cloumns
will get you the size that the table is taking out from the database.

however the sum of table sizes NOT= to database size on HD
D


ve*************@yahoo.com (Anand) wrote in message news:<13**************************@posting.google. com>...

Hi all

Please help me to find out table size in MS-SQL

how can I count or identify, this specific table is using some xyz kb
of space of my hdd.

thanks

Jul 20 '05 #2

Thilo Immel

Anand,

Hi all

Please help me to find out table size in MS-SQL

how can I count or identify, this specific table is using some xyz kb
of space of my hdd.

thanks

Is'nt there a topic at the enterprise manager? Just click at your
database an then have a look at the right windows: Tables & Indices (I
have only SQL Server 7.0, but I think this option is not dropped at
newer versions)

Regards

Thilo Immel
www.sql-server-repair.com

Jul 20 '05 #3

Anand

thanks, for your help..
actuly, I want to know exact utili(s)zation of the HDD, by one table.

thnaks
ve*************@yahoo.com (Anand) wrote in message news:<13**************************@posting.google. com>...

Hi all

Please help me to find out table size in MS-SQL

how can I count or identify, this specific table is using some xyz kb
of space of my hdd.

thanks

Jul 20 '05 #4

Dan Guzman

Try:

EXEC sp_spaceused @objname = 'MyTable'

To ensure the reported space reserved is accurate, you can add parameter
@updateusage = 'true'. See the Books Online for more information.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Anand" <ve*************@yahoo.com> wrote in message
news:13**************************@posting.google.c om...

thanks, for your help..
actuly, I want to know exact utili(s)zation of the HDD, by one table.

thnaks
ve*************@yahoo.com (Anand) wrote in message
news:<13**************************@posting.google. com>...

Hi all

Please help me to find out table size in MS-SQL

how can I count or identify, this specific table is using some xyz kb
of space of my hdd.

thanks

Jul 20 '05 #5

Thilo Immel

Anand,

thanks, for your help..
actuly, I want to know exact utili(s)zation of the HDD, by one table.

This is the exact utilization what the enterprise manager says. I have
not tested for image fields (they are not stored at the record itself,
but in so-called large value pages). Maybe they are not calculated
correct.

We have build a freeware tool for calculate the amount of disk space,
MS Access tables occupies (Access Memory Reporter, see
www.atroplan.com/AccMemoryReporter.htm). Access and SQL Server
structures are most the same. There are pages (Access 2000: 4 kByte,
SQL Server 7.0: 8 kByte for example) which each belongs to one table.
(hmm, I have to say, that Access 2.0 structure and SQL Server
structure are mostly the same, Access has a new structure up from
Access 97)

Even if a page is not filled completely, the whole page belongs to one
table. So you have to count the pages to calculate the disk space the
table needs. This is the way the enterprise manager calculate.

What do you want more?

Regards

Thilo Immel
Access Repiar Service www.atroplan.com
SQL Server Repair Service www.SQL-Server-repair.com

Jul 20 '05 #6