Posted by MC on 04/30/07 19:11

I would assume that index is fragmented and the record count is not the same
as far as I can see....


MC

<war_wheelan@yahoo.com> wrote in message
news:1177944218.213649.294530@n59g2000hsh.googlegroups.com...
>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: Create One Trigger For Both Update and Delete
• Prev in forum: Replicating database btw two sites why aren't the tables identical in size?
• Thread view: Re: Replicating database btw two sites why aren't the tables identical in size?

[Reply to this message]