ReplTip – Breakout by Article
My friend Brendan Odwyer gave me great query to show Distribution database breakout by article for Transactional Replication publications. We used this to identify 1 table that had +90 million rows pending in the Distribution database as result of a large bulk update. It would have taken Replication days to move that bulk down row-by-row.
Read More »