Physical Stats - SQL Server Forums

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 2005 Forums

Transact-SQL (2005)

Physical Stats

Author

Topic

Frozen_123
Starting Member

33 Posts

Posted - 2008-09-08 : 12:10:37

Hi All,

Does anyone have a script that I can use to determine the physical size a table would be based upon table schema, number of rows and fill factor?
This is for SQL 2005.

Thanks in advance.

Regards,
Frozen

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-09-08 : 13:40:58

Not me, but here is an article on how to do it:

http://msdn.microsoft.com/en-us/library/ms175991.aspx

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources