• 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)

You rated this post out of 5. Change rating

2013-09-30

6,492 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

Initial Config of tempdb

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Initial Config of tempdb

Db growth rate

By mtz676

Sample data: jan   10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...

Reference for doing Data Warehousing in SQL Server

By pietlinden

Everybody (well almost) knows that if you want to learn the design patterns for...

Visit the forum

Question of the Day

Initial Config of tempdb

What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?

See possible answers