Posted by war_wheelan on 04/30/07 14:43

I am replicating an 80GB database between NY can CT and would like to
know why table sizes are different between the two.

Here is an example of sp_spaceused::
NY IOI_2007_04_23 rows(279,664) reserved(464,832)
data(439,960) index_size(24,624)
CT IOI_2007_04_23 rows(279,666) reserved(542,232)
data(493,232) index_size(48,784)

Thanks,

• Next in forum: Re: Replicating database btw two sites why aren't the tables identical in size?
• Prev in forum: Create One Trigger For Both Update and Delete
• Thread view: Replicating database btw two sites why aren't the tables identical in size?

[Reply to this message]