Forum Discussion
SQL Server Transactional Replication
Hi All -
We are managing Large tables using Transactional Replication. I noticed the table is vertically published after adding a new column in the source.
Performance perspective, will it make any different for large table being published vertically vs horizontally.
Thanks,
Kranp.
Yes, vertically publishing large tables (i.e., replicating only selected columns) is generally better for performance than publishing the entire table horizontally — especially when:
- The excluded columns are large (e.g., XML, LOB, JSON, audit fields).
- Subscribers don’t need all columns.
- You're dealing with high write volume or bandwidth sensitivity.
