Yes... i agree that the meannig of "perfomance" depends on many aspects, such as

-network trafic

-network bandwidth

-cpu

-Data/Address bus width

-how busy is sql server (sql server trafic... i can say

Dear Gila, by better performance i mean less CPU time.... and i explain:

I did the following.... (hopefully correct):

I ran on the QA the follwing queries:

SET STATISTICS TIME Off

DBCC DROPCLEANBUFFERS...

ok,... lets start from the beginning:

The tables that i use are:

CREATE TABLE [dbo].[Items] (

[ItemID] [int] NOT NULL ,

[Item] [varchar] (50) COLLATE Greek_CI_AS NULL ,

[Price] [money] NULL

) ON [PRIMARY]

with PK...

Consider the three equivalent queries (produces the same results set):

--query 1: Using all consitions in the ON clause.

select o.Orderid, o.line, i.item

from items i inner join orderlines o

ON i.Itemid = o.Itemid

AND...

Accurate.... Gila, accurate!

I can suggest a (theoritical) solution to the problem without applying any code.... i thing it is not very dificult to implement.

Write a procedure to:

BEGIN

Step 1: Lock the table you...

The code bellow updates just fine the Remote Table:

exec sp_addlinkedserver 'OutServer', N'SQL Server'

go

update [OutServer].MyDB.dbo.Items set Price = Price * 1.1

go

exec sp_dropserver 'OutServer', 'droplogins'

go

Did you try something like tha above?

Also, i...

I agree with Karl & John....

I thing that the query optimizer has the answer. Using execution plan you can see how... and (hopefully) why.

If I understand you want to make the join in the WHERE clause,... something like this:

select A.*, B.*

FROM TABLEA A, TABLEB B 

WHERE A.Id = B.FId

which is a 100% valid sql...

Sorry,... but could you be more specific in your description... because the code is too long 4 me to read

What is the output...

Millions of rows you say?...

Be carefull because you can finally end-up with a record set with hundrends or maybe milions of columns....

R u sure there no 'ContractID' in Table1 ???

If this is the case.... the reason is... obvious!

...I am affraid that the link is not "reachable"..!! unless there is a problem with my ADSL-provider...

--Ciao domenico... I hope the following script will help...

--On SRV3 you can execute the following commands

---- Inform the system for the other servers

exec sp_addlinkedserver 'SRV1', N'SQL Server'

go

exec sp_addlinkedserver 'SRV2', N'SQL...

I have two tables

Cst (for customers) and

Prd (for Products):

I will display the values of Product Code (PrdCode) with column title the 'CstFullName' that I get from Cst (Customers):

===================================================================

declare...