|
kensai
Posting Yak Master
172 Posts |
 Posted - 02/24/2012 : 08:56:18
|
I'm using a simple update statement over a linked server. Servers are on the same network with gigabit connections (pings are <1ms), I'm using sa account on both server and for the update connection and the table has non-clustered indexes on where clauses. Queries take minutes to complete if not end up with timeout.
Are there any solutions other then sending values to a linked server sp and do updates there?
|
|
Extremely slow update over linked-server
