SQL Server 2016 Developer's Guide

Querying Stretch Databases

When you query a Stretch Database, the SQL Server Database Engine runs the query against the local or remote database depending on data location. This is completely transparent to the database user. When you run a query that returns both local and remote data, you can see the Remote Query operator in the execution plan. The following query returns all rows from the stretch T1 table:

USE Mila; 
SELECT * FROM dbo.T1; 

As expected, it returns five rows:

id          c1                   c2
----------- -------------------- -----------------------
2           Manchester United    2016-06-02 00:00:00.000
4           Juventus Torino      2016-06-25 00:00:00.000
5           Red Star Belgrade    2016-06-25 00:00:00.000
1           Benfica Lisbon       2016-05-15 00:00:00.000
3 Rapid Vienna 2016-05-28 00:00:00.000 ...