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 2018-02-02 00:00:00.0004 Juventus Torino 2018-02-25 00:00:00.0005 Red Star Belgrade 2018-02-25 00:00:00.0001 Benfica Lisbon 2018-01-15 00:00:00.0003 Rapid Vienna 2018-01-28 00:00:00.000 ...