Category: Try This

What happens if I select Create a snapshot immediately in the Publication Wizard?

Share this PostWhen creating a Transactional Replication publication, what happens if I check Create a snapshot immediately and keep the snapshot available to initialize subscriptions? This sets the publication property @property=‘immediate_sync’,@value=‘TRUE’ which instructs Replication to keep all the transactions cached in the Distribution database for the entire Retention Period.  Normally these rows are purged as
Read More »

Visual Studio Utility to Compare 2 SQL Server Databases

Share this PostDuring performance troubleshooting we often need to look at difference between two different databases.  We’ve used SQL Server Tablediff Utility for the data changes but doesn’t help with schema changes.  For schema differences you can use Database Compare tool available for Visual Studio. How to: Compare the Data of Two Databases http://msdn.microsoft.com/en-us/library/aa833428.aspx Schema
Read More »

Executing batch UPDATE commands on Publisher and its affect on Transactional Replication

Share this PostJosé Moreira Neto | Microsoft SQL Server Escalation Services Problem 1: batch updates 1)      A single update command can generate a transaction with thousands of commands. For example if you execute an UPDATE statement that updates 10K rows on the publisher, up to 20K commands can be send over to the subscriber. On
Read More »