Table Sizes

[NeilV]

Hello...

I have a database that is replicated across two servers using transactional replication, which works ok. However, I have found that the table sizes on the primary and secondary servers are significantally different even though they have the same number of rows. The tables are far bigger on the primary server than the secondary one.
Any ideas why this is happening and how it could be fixed?

Cheers,

Neil

 

[mkal]

I'm guessing that due to inserts/deletes page splits have taken place. Page splits will increase the size of the tables on the primary server. Try reindexing your tables and/or shrinking the database. When you replicate to the secondary server the pages get filled completely and sequentially so they would naturally be smaller.