FIX: Queries on Stretch Database enabled databases always involves a network round-trip to Azure in SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core More

Symptoms


When you run a query that queries data from a table or a database that has Stretch Database enabled, the query always involves a network round-trip to the remote data on the Azure storage.

Resolution


The issue was first fixed in the following cumulative update of SQL Server:

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.