By the way, there is no foreign key relationship between .[ID] and the table being joined to from the top input.

Oh yes.

In the few reports I have looked at, deep down in the plan there is typically a hash join that is estimating that millions of rows will come out...

Thanks again for these points.

Regarding the current sql server max memory setting, there's a lot of history behind that setting value. But it's something we can revisit.

Anyway,...

1) Just to be clear, do you mean the hint MAX_GRANT_PERCENT requires Resource Governor? Only, it seems to be working fine without us enabling Resource Governor, insomuchas it's limiting...

Thanks for your responses.

For where we are right now, the criticality of the problem, and how little we are able to simplify the T-SQL in the offending reports in the...

An update for anyone who has followed this or one day stumbles across it.

Essentially, the problem is still unresolved and I have found it is NOT an AG listener issue....

One step closer. The evidence is mounting that this is an AG listener issue.

My test connectivity job occasionally times out trying to make a sql server connection...

Bit of an update on this one.

I suggested that Kerberos was incorrectly being used. Well, that's not entirely accurate. I now believe that an NTLM (using TCPIP) connection...

Brilliant! Thank you very much indeed!

Thanks for your reply.

Excuse my ignorance in this area but how do i check the character encoding in the file? I checked the properties of the file...

Just to say that I did indeed restart sql server agent (tecnically speaking, as it is a cluster i took the sql server agent resource offline and brought it online...

Thanks so much. I saw the WITH XMLNAMESPACES references in BOL but the examples seemed to imply the XML elements were themselves prefixed with the namespace declared within WITH...

I must admit i hadn't thought of it in that way. I always believed that connection layers and/or the code calling them had the choice of what to supply...

Brilliant! dm_exec_sessions also does not hold the hostname but dm_exec_connections does indeed have the correct IP address. I had forgotten about this other DMV.

Thanks so much - problem...

I currently use xp_cmdshell to help with dynamic restores, where a common backup directory (on a file server on the network) is passed to a restore stored procedure and the...