Home Forums SQL Server 2008 SQL Server 2008 - General The size of a table. (space_used against calculated space). RE: The size of a table. (space_used against calculated space).

  • June 10, 2013 at 9:11 am

    #1622488

    ben.brugman (6/10/2013)

    With sp_space_used you get the 'gross' size of a table. (Used_size for data)

    Summing all fields with a datalength function also gives a size for a table, offcourse this is without the overhead.

    The used_size is about 2 to 3 times the calculated size.

    So how can I calculate the size more accurately?

    Thanks for your time and attention.

    ben brugman

    This discussion of the subject may be of help to you.

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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]