Tag Archives: sql server index clustered nonclustered covering

How to set up SQL Server Transactional Replication : Multiple Publishers, Single Subscriber

  While providing a replication solution to one of my client in SQL Server 2016, I came across a scenario where the client had retail stores at various locations and all data from those stores had to be synchronized at a … Continue reading

Posted in SQL DBA Tutorials | Tagged , , , , , , | 4 Comments

Understanding Indexes in SQL Server

Indexes in SQL Server are created on columns in tables or views. The index provides a faster way to look up data based on the values in those columns. For example, if you create an index on the primary key … Continue reading

Posted in Uncategorized | Tagged | Leave a comment