I don't know how you are running/testing this, perhaps you could supply a readily runnable script like this:

declare @string varchar(8000);

set @string=' /*

YYYY/MM/DDOwner

-----------------------

data1X

data2+X

data3++X

data4+++X

*/';

select (select Item + left(' ...

The only reason to agree with not using "edit top 200" is because it is potentially dangerous to have people manually editing data, but it's not inherently bad - it...

/* Changes to provided code are :

1. move expression for "HeaderComments" into a cross apply, just so we can reference the resulting string in the call...

easy.

it was called "ChuckNorris" and it provided answers to stupid interview questions.

...walks out...

It doesn't guarantee the right order any more than your count() did, unfortunately - well at least not to my knowledge.

I have yet to see any documentation that guarantees that...

SELECT

ID = row_number() over(order by @@spid) ,

Type = R.value('local-name(.)','varchar(10)'),

Color = R.value('(Color/text())[1]','varchar(10)')

FROM @xml.nodes( '/Furniture/*' ) as a(R)

How does this work for you?

I didn't spot that you had provided sample data and a query...I'll take a look, but it does seem to be a non-optimal approach...

Is this one of the "flat" xmls that is relatively fast?

Because it doesn't look like a multi-level one from that query?

Aside from that, why are you using that flwor...

...

ORDER BY RowNumber;

That all depends on the precise nature of your query.

There are several ways to query the data from an xml document, and some perform better than others for different...

Well, sure, I could have provided you with that, but...

Local firewall software on the client taking a while to "allow" the connection? (try disabling any firewalls for a test)

Nameserver lookups taking a while? (still slow with ip address and...

itmasterw 60042 (1/5/2015)

I got this code, form a web site, that I can put in the Actions part of my Textbox property. When I click on the link it should...

exec master.dbo.sp_MSset_oledb_prop N'MSDASQL';

In addition to the previous advice, I would recommend that you grab a copy of those queries and performance test them.

I can see that you are hitting linked servers, and...