haw to calculate size of a table ? ( SQL2k ) 
Author Message
 haw to calculate size of a table ? ( SQL2k )
Hello,

I know how to do it manually, but i have too big database for choose this
way, so maybe there is any function or store procedure which calculate this
size ?

thanks for ideas
regards
Vir



Sat, 22 May 2004 04:35:31 GMT
 haw to calculate size of a table ? ( SQL2k )

Vir,

The CD accompanying "Inside Microsoft SQL Server 2000" by Kalen Delaney has
a stored procedure that encapsulates the logic found in the SQL Server Books
Online to estimate table size.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> Hello,

> I know how to do it manually, but i have too big database for choose this
> way, so maybe there is any function or store procedure which calculate
this
> size ?

> thanks for ideas
> regards
> Vir



Sat, 22 May 2004 07:56:59 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. size(MB) of table in SQL2K

2. Finding the size/#rows of tables and indices in SQL2K

3. Calculating table size

4. Calculating size of a Table

5. Utility to Calculate Table Size?

6. calculating the size of a table

7. Calculate table'size

8. Calculate log size for alter table add identity

9. Calculating Table Size

10. Calculate Table Size

11. How to calculate table size in mdb files?


 
Powered by phpBB® Forum Software