You could use OPENROWSET with SQL authentication. Although I think it would be better to set up a linked server and a login mapping for the linked server, as this...

Have you run a trace to see whether it is an overall slowdown, or whether it is some particular statement(s) that get hung?

I realise that this will take some time...

I seem to see the same thing. Probably a glitch in the SSMS GUI. (Which I never use.)

You can always issue ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMIEDATE followed...

It's as easy as this:

SELECT format(getdate(), 'MM/dd/yyyy HH:mm:ss')

Since we don't have access to your system and have to rely to what you tell us, I think our odds to sort this out are slim. Most likely, something...

The solution I posted works for this string as well:

with tmp as (

select x = 'some text-1'

union select x = 'some text-123'

union...

If you want a query that has been tested, you should include

1) CREATE TABLE statements for your table.

2) INSERT statements with sample data.

3) The desired result given the sample.

You could...

Performance of XQuery is not always fantastic, and sometimes seemlingly trivial changes can have huge impact on performance.

In the XML section of my article on Arrays and Lists in SQL...

I'd say that on most developer/training computers (like Jacob's) Agent is...

If I understand this right, this MERGE statement should cut it:

MERGE dbsource

USING (SELECT DISTINCT Raw_SW_Manufacturer,Amended_SW_Manufacturer,

Raw_Product_Version,Amended_Product_Version,

...

Thorkil, which of these lists do you think is correct:

Aalborg, Aarhus, Amager, Bornholm, Ringsted, Ærö, Øresund

Amager, Bornholm, Ringsted, Ærö, Øresund, Aalborg, Aarhus

There you have it.

If this is a one-off you could do:

UPDATE issues

SET category = (SELECT MIN (k.category)

...

Your highest wait type is CXPACKET, which indicates that you have a lot of (unbalanced) parallelism.

My approach to a situation like this is to set up a trace where I...

Not Invented Here!

Correct, sp_WhoIsActive is a very comprehensive work by SQL Server MVP Adam...

So Agent was running until someone shut down Windows, and since then it does not start. And it does not come as far as writing SQLAGENT.OUT.

Have you check Windows Event...