hendy1967
asked on
Best way to join tables on different servers?
hi what is the best way to join a table from on sql server to another. Prefixing it with server and database is very slow. I beleive open rowset is best way but is there any other and what is the syntax?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and if it's slow, it will eventually depend on the join syntax you are doing...
there is no single magic solution to all situations.
you might consider:
* changing the query
* replicating the remote table(s) to the local db
* locate the query/job on the other database
* ...