Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Table Size estimation

Author  Topic 

ramdas
Posting Yak Master

181 Posts

Posted - 2003-04-29 : 11:03:25
Hi Folks,
I am using the taskpad view of the enterprise manager to get table size. When I divide the number of rows by the table size the result is the size of a row in kb correct? Is the size showed by EM correct?
Is there any other way to calculate the size of a table. I am doing capacity planning for a historical database.

Bye
Ramdas

Ramdas Narayanan
SQL Server DBA

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-04-29 : 11:16:16
Go to
http://www.nigelrivett.com/

nr has a script for calculating space used in all tables.

Go to Top of Page

ramdas
Posting Yak Master

181 Posts

Posted - 2003-04-29 : 11:23:40
Hi folks,
Thank you
Bye

Ramdas Narayanan
SQL Server DBA
Go to Top of Page
   

- Advertisement -