July 28, 2003 at 6:22 am
As someone experienced the difference between using a linked server instead of distribuited queries?
Thanks in advance
July 28, 2003 at 10:25 am
If you are going to execute the query more than once, or frecuently, you shoud use a linked server.
But for one time execution, it is the same.
July 29, 2003 at 7:51 am
When you have only a small portion of the remote table that you need in the linked server query (for example 2 columns out of 200) , use OPENQUERY([Server],'Select') to return only the necessary records. Saves network resources.
July 29, 2003 at 2:18 pm
If you have the disk space and the server resources available, you might want to try replicating the queried tables from one server to the other. That way the query will be running on the same instance and your performance will improve substantially.
Bill Bertovich
Bill Bertovich
bbertovich@interchangeusa.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply