March 22, 2010 at 12:16 pm
Hi Members,
Could you please tell me anyone that what is the difference between querying data from remote server and linked server.
performance wise as well. What are the things I have to consider while querying the data from a different server.
thanks in advance.
Regards,
tal
March 22, 2010 at 12:36 pm
love sql (3/22/2010)
Hi Members,Could you please tell me anyone that what is the difference between querying data from remote server and linked server.
performance wise as well. What are the things I have to consider while querying the data from a different server.
thanks in advance.
Regards,
tal
A remote server is any server that you are querying from a different machine. Thus a linked server could also be a remote server. A linked server is one in which you setup a link on the source server to connect to the other server. This will allow you to run queries against it without creating a new connection, and thus tie data together from different servers in a single query.
Performance implications - network, improperly configured linked server can cause both servers to lag, big queries can cause both servers to lag.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply