I'm not an xquery guru, but it could be possible that there are no cached plans that include an index scan on the table/index you are searching. I ran...

I believe you should see it in Profiler if you have selected the correct events. What events are you collecting?

Interesting. What happens if you just eliminate the linked server part of the query?

What is the default schema of the user?

Ahhh, now I don't feel too bad for not having a better answer. At least I asked some different questions.

What are you doing across the linked server?

Edit: I had left "you" out originally.

Yes once for each database selected.

When you say you get different results do you mean execution time or actual data? If different data, are the results consistent within users?

Are you schema qualifying the objects...

Yes it is possible, but you will have to either use Dynamic SQL or use a temporary table to hold the results form the query against each database with IF...

First where are the failed logins coming from (HostName, Application Name, and IP Address in TextData)? If all the failures are coming from the web server then you need...

A CU is a cumulative update of fixes that is not as rigorously tested as a service pack. These fixes can change the behavior of code so that what...

Obviously you are using at least SQL Server 2005 so you posted in the wrong forum (2000).

Is this a shared login? Is this login used by some...

I can't answer all your questions, but I will comment.

You either need to rebuild OR reorganize indexes not both. The rule of thumb is to rebuild if fragmentation is...

Well, you could do it, but typically you want to be able to try out new queries on test databases and you may have a poorly written query or a...

Is this something you need to do regularly or a one time thing? Profiler or a server-side trace is one option. Another would be to create a table...

While I have not tested any of the solutions presented I am pretty sure, based on past experience with these posters, that they will all work fine, but

I usually recommend...