Re: how to know if query is processed in remote server
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 23 Jul 2009 22:32:15 +0000 (UTC)
Claudia (Claudia@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
declare @t table (
NameKey int not null
)
insert into @t
select NameKey
from my_linked_server.myDB.dbo.myTable
One of the steps in execution plan shows "Remote Query". Does this mean
the data has been selected on remote server before it's pulled over to
the local server?
Yes, but you need to look closer to see which query. In this case it's
trivial, but you have a more complex query, you may not want to see the
remote table in entirety being brought over to the local server.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: how to know if query is processed in remote server
- From: Claudia
- Re: how to know if query is processed in remote server
- References:
- how to know if query is processed in remote server
- From: Claudia
- how to know if query is processed in remote server
- Prev by Date: Re: How to import one DB to another using any tool
- Next by Date: Re: Find parameters in Stored procedures that are required
- Previous by thread: how to know if query is processed in remote server
- Next by thread: Re: how to know if query is processed in remote server
- Index(es):
Relevant Pages
|
