David.Poole (12/18/2009)
The article was mainly about standard edition.The killer feature for enterprise users is the ability to switch partitions on replicated tables. This means that with careful design the purge of millions of records can be achieved in the blink of an eye without thrashing the disks and transaction log.
that's our biggest problem
we have a database that is refreshed every 45 days on average. new data comes in every few days and old data is archived. some days the archive process deletes 50 million rows and it kills replication. tried a lot of things to avoid rerunning the snapshot but no luck