• Wouldn't it be incorrect to compare this script to an existing table, since the script is meant to estimate a table's size

    Sqlfrenzy (7/2/2009)


    dant12 (7/2/2009)


    according to your script one of my tables has 440 MBs but SSMS says it has around 46 MBs

    u sure u did the math right?

    I tested the script against the 7 tables of adventureworks database...5 tables gave me result with a margin +1/-1..