Tag: partitions

Very Slow Data Repartitioning in SQL Server Replication with Precomputed Partitions

Here is a great posting by Kevin Locke on a problem he encountered when data modifications occurred near the top of a complicated replication filter configuration.  These changes can cause “partition change” which triggers re-evaluation of all child data; also known as “repartitioning”.  Kevin’s solution was to add an index to the Merge tracking tables,
Read More »