472,333 Members | 2,457 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,333 software developers and data experts.

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

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,

Apr 30 '07 #1
1 1251
MC
I would assume that index is fragmented and the record count is not the same
as far as I can see....
MC

<wa*********@yahoo.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.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,

Apr 30 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Nathan Simpson | last post by:
Hi, We have one domain with a mixture of NT PDC's one Win2K DC (which was the first installed) and 4 Windows 2003 DC's. I created our sites as...
9
by: LRW | last post by:
So I've been using CSS for a year now pretty much only as a replacement for FONT tags. I know you can do a LOT more with them, though. Like,...
9
by: LRW | last post by:
So I've been using CSS for a year now pretty much only as a replacement for FONT tags. I know you can do a LOT more with them, though. Like,...
25
by: pereges | last post by:
Hello, I'm trying to build a database driven website for a library management system. The database is stored on a remote server which all of my...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.