• Interests: SQL Server Performance and Code-Quality

SQLServerCentral Article

The Fundamentals of SQL Server Replication by Sebastian Meine

Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implemen­tation of such a requirement.

2 (7)

2013-09-30

6,468 reads

Blogs

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Typing with Your Tongue Part 2: Voice Access

By

A few months ago, I wrote a post on how I use voice technology...

Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up

By

William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...

Read the latest Blogs

Forums

Usage of #TempTables and an Index in Stored Procedure

By BOR15K

We have a stored procedure, working for yonks, which has a CREATE session temp...

Referencing a table type In Dynamic SQL

By Weegee71

I want to use a table variable in a merge statement using Dynamic SQL...

modify dtsx connection

By roshanbi

Hello Team, kindly advise how to change dtsx connection? below is source details: Data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers