Chapter 15

Executing Distributed Queries

In This Chapter

Understanding a Distributed Query Overview

Developing Distributing Queries

Using Distributed Transactions

Considering Performance

Data is everywhere. Even within the walls of a company, you never find data in the same place. As the amount of data increases within an organization, the need to access that data using distributed methods becomes even more critical. With SQL Server, getting to and querying distributed data is not a problem; SQL Server can access data from a plethora of data sources.

SQL Server provides several methods for accessing data from many different external data sources from a source location. This chapter discusses the methods for accessing and querying distributed data.

Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.