Tips for using Merge Replication in SQL Server 2019 (Part 1) Consider setting the -MaxNetworkOptimization parameter of the Snapshot Agent to 1 to avoid sending irrelevant deletes to the Subscriber. Irrelevant deletes are DELETE commands that are sent to Subscribers for rows that do not belong to the Subscriber’s partition. The default value of the -MaxNetworkOptimization is 0. Setting -MaxNetworkOptimization…
This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Register
Already a member? Log in here