We set up two linked servers from on SQL Server instance to another SQL Server instance. One using our ODBC driver for SQL Server and one using our OLE DB provider for SQL Server.
We tested using a table with 500000 rows, 7 columns and 5 different datatypes.
We ran the performance tests using both the OPENQUERY syntax and without the OPENQUERY syntax but the performance is quite close between the two syntax.
... View more