Thank you mkempanna. Performance will depend on which SQL queries you run through the Linked Server. For example, complex queries are typically faster when pushed down to the database using OPENQUERY. If you just select * from the table, both syntaxes will perform similarly.
... View more
