Replicating database btw two sites why aren't the tables identical in size?

#1

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,

#2

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

MC

<war_wheelan (AT) yahoo (DOT) com> wrote

Quote:

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,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Replicating database btw two sites why aren't the tables identical in size?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Replicating database btw two sites why aren't the tables identical in size? - 04-30-2007 , 09:43 AM

Re: Replicating database btw two sites why aren't the tables identical in size? - 04-30-2007 , 02:11 PM