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 |
|
kensai
Posting Yak Master
172 Posts |
 Posted - 2012-02-24 : 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? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2012-02-24 : 10:35:51
|
| Is it just a simple update or are you joing tables from both servers? |
 |
|
|
|
|
|
Extremely slow update over linked-server