Is it a Good practice to use JOINS over a Linked Server? If Not, what is the alternative so that I can make use of Linked server and get the required data?
a join to a linked server could slow your query down quite a bit. An alternative would be to replicate that table from the remote host to your local system. There are obvious downsides to that solution also.
Linked Server
Posted - 08/01/2007 : 15:58:20
