Just to close this thread...

We restored the performance of the query. It is unclear when the server had its previous reboot and so the suspicion is that the recent...

Interesting(?) observation on my problem.

When query is run from Query Analyzer on a client PC it retuns in a second, and the wait attributable to the query is all CXPACKET

When...

Hi Pablo

Thanks for your interest:

1) Unfortuantely Tracert shows nothing of any concern, and our network guys have also given things the once over

2) The linked server has been...

I'm still not having any luck resolving this.

If you find a solution please let me know (Did yours happen after a reboot - what was the trigger for...

Thanks for the suggestion, but the symptoms don't quite match what I'm experiencing. Just as a further update, when navigating the linked server folder on the local server (in...

Jeff/Roy,

Thanks for the suggestions. Will try them out and let you know how I get on. I'm suprised that any of these things can intermittently add 40 secs...

Hi,

The server hosts only DB - no applications. It is Server 2008 running SQL 2008 (64bit).More monitoring shows that it is only ever this query that hangs - a...

Thanks for all the replies. As a testing exercise I added NOWAIT but that didn't sort the problem. I've done some more investigating and found that every now...

Thanks to both. Used a staging table with a stored procedure in the end and it works very nicely.

Thanks again.A.

Many thanks to all. I plumped for the XML variant in the end as it fits my existing stored procedure quite nicely.

Cheers,

Andrew

That's a great start. Thanks.

This statement 'serializes' the whole table. I need to be able to have one serialization per key field, if that makes sense.

I.e.

1 abc;def;ghi

2 jkl;mno;pqz

at...

Thanks for the links. They haven't solved my problem but did lead me to a config setting that allows me to allow users to type in an email...