Link to home
Start Free TrialLog in
Avatar of hendy1967
hendy1967Flag for United Kingdom of Great Britain and Northern Ireland

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?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

no other, from what I know...

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
* ...
ASKER CERTIFIED SOLUTION
Avatar of subhashpunia
subhashpunia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial