I have a loopback linked server in SQL2005 that uses openquery. When I run
the statement using openquery, this query take 40 seconds. When I don't use
the linked server, the query completes in 3 seconds. We have this same
system in SQL2000 using the same openquery and linked ...

I want to learn how to get the most performance out of T-SQL code.
essentially I want to learn to be able to rewrite T-SQL code to get better
performance out of stored procedures. What would you recommend is the best
AND fastest way to learn that? I am more interested in leaning ...

How can I import an xml file to SQL at the same time every night?  I will
need to create a new database first via the import after that I will be
appending to the database.  Then I need to xport the data into a difference
xml file.

I wonder if anyone can shed any light on the following as i just can't
explain it.
A user is running an update on a 500m+ row table setting a column
value, computing its value from another column in the table. It's now

when calling UPDATE from the result set of a SELECT statement, is the order
in which rows from the SELECT statement 100% geronteed?
tableA
myid