Tag: MSarticles

ReplTip – Breakout by Article

Chris Skorlinski [MSFT] Troubleshooting, Try This September 21, 2015

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 »