Data space size of a replica Table in a database varies. RRS feed

  • Question

  • If a table A has been scripted and all its data bas been copied using bcp onto a new table B than row count looks the same but why does the data space size is less by 30 MB on Table B.

    If the both the data in tables are identical then the data space size should also be the same.Isn't it?

    we have created partiions on table B. Does partitioning a table reduces its data space size?


    Saturday, November 8, 2014 1:54 PM


  • Hi,

    It depends, you need to check the fragmentation on the table, over a time tables get fragmented and consume lot more space, where us newly created table are compact with very less fragmentation. You start by checking fragmentation and number of pages used in old and new table.

    Here are few ways to do it:

    • http://msdn.microsoft.com/en-us/library/ms188917.aspx
    • http://msdn.microsoft.com/en-us/library/ms175008.aspx

    Regards Harsh

    • Marked as answer by Born4sqldba Saturday, November 15, 2014 5:52 AM
    Saturday, November 8, 2014 2:25 PM