crazywolf2010
asked on
Linked Severs on MS SQL 2008R2
Hi,
Does anyone have a brilliant example of how 2 remote servers between 2 data enters could be linked so one SQL statement can access both data sets?
I am looking for example to give details of ports used, sp_configure config needed, any drivers used between servers and security issues which I need to be prepare for.
Thanks
Does anyone have a brilliant example of how 2 remote servers between 2 data enters could be linked so one SQL statement can access both data sets?
I am looking for example to give details of ports used, sp_configure config needed, any drivers used between servers and security issues which I need to be prepare for.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For performance reasons, it doesn't take much for it to be better to get one result set from remote server a & save in a temp table, and another from remote server b and save that, then process the result.
Multi-server joins can perform very badly! In short, the query optimiser needs to figure out who has the smallest result set, and transfer that to the other server, and then perform the resulting query. Its somewhat tricky to do nicely.
HTH
David