"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

August 07, 2009

Linked Server and FAQ

Today I got a question on using linked server, Below links I found useful

How to Achieve High Performance with Linked Servers
Test linked server connection settings
Performance Problem while reading from Linked server
Net Net it is preferred to have the data locally and execute query than using linked server as it might be a performance killer. There are some hints than can be specified, We would discuss it in next post.

No comments: