Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Amit Jethva DATABASE / TABLE SIZE ESTIMATER RE: DATABASE / TABLE SIZE ESTIMATER

  • June 10, 2010 at 10:29 am

    #1178745

    Did you enter data that filled all variable length fields completely? Remember: Amit's code estimates the size of the table based on every variable length field being completely filled in. So, if a variable length field is varchar(200), his script will estimate the size based on that field being completely filled with 200 characters versus, let's say, only 10.

    Hossam AlFraih (12/2/2009)

    Hossam AlFraih (6/19/2009)

    Hi Amit,

    I used the script on one of my tables it gives me about 600 MB for 400,000 records.

    I filled that table with "actual" data (400,000 records) and It is only 150 MB!

    Note: There were one clustered index (PK) and 4 non-clustered indexes in that table.

    Any explanation for this big different?

    Thanks

    I hope to get a reply very soon.

    Thanks

    Hossam