Post reply

Database Size Difference

  • April 28, 2010 at 6:21 am

    #234312

    Hi Experts,

    We haev two database which are loaded from same source using same jobs.But still they have diffrence size.

    I ahev check ed the columns and found to have difference in some tables by some few millions records. The difference in .mdf file size is by around 20GB. I hope few millions records wont make that much difference.

    Many Thanks

  • April 28, 2010 at 7:13 am

    #1158880

    Depending on the data types, of course a few million records could produce a difference of 20gb. Actually, the data types involved must be quite small for several million records to only produce a 20gb difference.

    I'm not sure where the confusion comes from here.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 28, 2010 at 7:16 am

    #1158885

    Thanks Grant

  • April 29, 2010 at 11:33 am

    #1159938

    apart from above reply,

    If those few million rows were inserted separately later, then the database mdf size might have grown to more extent for that operation and then probably backup was taken. You may want to shrink the file if there is little more unallocated space.

  • April 29, 2010 at 11:21 pm

    #1160180

    Thanks apat 🙂

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

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