Physical Stat

Question

Physical Stat

Austin_123

SSCommitted

Points: 1648
More actions
September 8, 2008 at 10:11 am

#71905

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,
Austin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

An existing table, or a hypothetical table?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

Have you looked at the reports included in SP2 of SQL Server 2005? There are a series of reports having to do with table size, which should give you the ACTUAL information, and not just a guess/estimate of the size.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Steve Jones - SSC Editor SSC Guru Points: 734826 More actions · Answer 3

Haven't tried it, but this might help you: http://www.sqlservercentral.com/scripts/Miscellaneous/31062/

Jeff Moden SSC Guru Points: 1003948 More actions · Answer 4

... and, to understand more about how that script works, please lookup "Estimating Table Size" in Books Online.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)