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 |
|
Sean_B
Posting Yak Master
111 Posts |
 Posted - 2010-03-02 : 11:39:57
|
| Hisome time ago I came across the problem of executing an "outer apply (select top ..." statement across a linked server, where the performance is very slow, whereas the same statement run s very quickly when executed in the remote database. Can anyone point me in the direction of an article describing this issue, I've tried searching for this but to no avail.I just wanted to refresh my memory of why this is an issue and if there are any ways around it.thanksSean |
|
|
|
|
|
outer apply (select top 1 .. across linked server