Editorials

More in this category »

SQL Server

More in this category »

From the Community

More in this category »

Other News

Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 distributed queries

Tips for using SQL Server 2017 distributed queries Try to avoid using the TOP clause in the distributed queries. Because distributed queries that involve the TOP clause are never delegated to an OLE DB provider and are always evaluated locally, you should avoid using the TOP clause in the distributed queries to increase the local SQL Server performance. The first...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register