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

[Don]

Re: Table size count

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




versatile_anand @yahoo.com (Anand) wrote in message news:<13d31bbd. 0409300109.2bda b7fe@posting.go ogle.com>...[color=blue]
> 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[/color]

[Thilo Immel]

Re: Table size count

Anand,
[color=blue]
>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[/color]


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

https://www.sql-server-repair.com

[Anand]

Re: Table size count

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

thnaks


versatile_anand @yahoo.com (Anand) wrote in message news:<13d31bbd. 0409300109.2bda b7fe@posting.go ogle.com>...[color=blue]
> 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[/color]

[Dan Guzman]

Re: Table size count

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" <versatile_anan d@yahoo.com> wrote in message
news:13d31bbd.0 410010332.73d81 6e9@posting.goo gle.com...[color=blue]
> thanks, for your help..
> actuly, I want to know exact utili(s)zation of the HDD, by one table.
>
> thnaks
>
>
> versatile_anand @yahoo.com (Anand) wrote in message
> news:<13d31bbd. 0409300109.2bda b7fe@posting.go ogle.com>...[color=green]
>> 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[/color][/color]

[Thilo Immel]

Re: Table size count

Anand,
[color=blue]
>thanks, for your help..
>actuly, I want to know exact utili(s)zation of the HDD, by one table.[/color]

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