Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chintu22oct
Starting Member
2 Posts |
 Posted - 2007-12-06 : 03:21:13
|
| I have setup linked servers between a few servers in our organization. I can execute distributed queries on the linked server but when i try to insert the results of the query into a local table, the query runs for an insane amount of time. What is it that you suggest i do?--------------->Chintu |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-06 : 03:26:55
|
How fast is your network?Because when you execute distributed queries, they are performed at the target server only.When executing a distributed query AND copying the result to you local machine, all data needs to be sent over the network.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Inserting results of query run on linked server