Annotations for "How Merge Replication Tracks and Enumerates Changes" topic. Fri, 26 Dec 2014 01:17:08 Z Rob Tiffany Reducing SQL Server Sync I/O Contention $0One of the features that makes SQL Server Merge Replication superior to other sync technologies is something called Precomputed Partitions.  SQL Server creates and maintains distinct data partitions/subsets for each unique user or other type of filter value.  Other sync technologies figure out “what’s-changed” on the fly when a Subscriber synchronizes.  This means all change-tracking tables must be evaluated to figure out the data-delta while the user (not so patiently) waits.  Merge Replica Mon, 28 Feb 2011 23:45:55 -0800