• 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