server: set up same on different servers, but different res

We have a linked server set up the same on 2 servers, but a query from one
server executes different on the remote database. A Query from one server
executes quickly, while the other causes table scans on the remote server,
per Profiler.
I couldn't see any differences on the query received on the remote, but then
again the slow query never completes, it times out...
I checked all the options through sp_configure, etc on the database and
server, but couldn't find any differences. My first guess was something like
a quoted identifier, etc, but they seem to be the same.
Any thoughts?
thanks!
-SteveTwo questions:
* Are indexes set up the same on both servers?
* How are you linking the remote server? It will definitely make a
difference if the system is processing a pass-through query v. pulling the
remote server data over to filter it locally.
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"smoss" <smoss@.discussions.microsoft.com> wrote in message
news:460ECCF5-7B7C-4B88-BDDF-44010DB68C84@.microsoft.com...
> We have a linked server set up the same on 2 servers, but a query from one
> server executes different on the remote database. A Query from one server
> executes quickly, while the other causes table scans on the remote server,
> per Profiler.
> I couldn't see any differences on the query received on the remote, but
> then
> again the slow query never completes, it times out...
> I checked all the options through sp_configure, etc on the database and
> server, but couldn't find any differences. My first guess was something
> like
> a quoted identifier, etc, but they seem to be the same.
> Any thoughts?
> thanks!
> -Steve
>