Warren's DBA Stuff Blog

Things of interest to SQL Server Database Administrators.

Warren's DBA Stuff Blog

  • Record deletes on referenced tables and deadlocks

    While troubleshooting some intermittent deadlocking in one of my databases I was surprised to learn that both commands were deleting single rows from different tables and both lookups were on indexed values. The commands were table scanning and deadlocking...
  • SQL Server Replication: Synchronize From Backup

    Synchronize from Backup is the first of the "No Sync" scenarios and is typically the next scenario people look at when automatic synchronization becomes impractical Synchronize From Backup This method cannot be done from the GUI and must be done...
  • SQL Server Replication: Automatic Synchronization

    The simplest transactional replication synchronization scenarios involve a single publication and one or more subscribers. In most cases the complexity changes very little whether or not a remote distributor is involved, so it's omitted in most diagrams...
  • SQL Server: Transactional Replication Resynchronization

    Introduction Initializing transactional replication for the first time or reinitializing when it goes out of sync can be frustrating but knowledge and planning can take most of the pain out of it. This guide is designed for SQL Server database administrators...