Re: Linked server execution plans

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 22:20:47 +0100

Having a stored procedure on the linked server, and calling it using 4-part
name acceptable in this case? 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Charles J Ryan" <charlesryan1@msn.com> wrote in message
news:eNb9Bz6iEHA.3612@TK2MSFTNGP12.phx.gbl...
> I have created a linked server to a non sql server database using the
OLEDB
> for ODBC provider.
>
> When I issue a simple query such as:
>
> select * from linked_server..schema.table_name where field1 = '111111'
>
> It takes the same amount of time as:
>
> select * from linked_server..schema.table_name
>
> Looking at the execution plan the reason for this becomes obvious. The
plan
> always uses a table scan passing only the select portion of the query, and
> then applies a filter with the where clause once ALL records have been
> retrieved from the linked server.
>
> Is there any way to override the execution plan and force it to pass
through
> the entire select statement, including the where clause, for the remote
> server to process without using OPENQUERY?
>
>

Relevant Pages

  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • Re: Microsoft Excell Connection
    ... Use your linked server to Access then as the source by adding a SQL Server ... You should be able to add an Access Connection to a secured Access MDB ... properties enter the location of your system database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 linked server problem
    ... The delegated Kerberos authentication does not work stably. ... of SQL Server 2000 to fix some known bugs on the SQL Server side. ... the both two SQL Server instances (local and linked server), ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2000 linked server problem
    ... if we are able to connect the linked server ... successfully on the SQL Server itself but fails to connect from the remote ... client, the most common cause of this behavior is the delegation problem. ... If Windows Firewall or other third party firewall is used, ...
    (microsoft.public.sqlserver.connect)