Viewing 15 posts - 1 through 15 (of 28 total)
By the way, there is no foreign key relationship between .[ID] and the table being joined to from the top input.
November 15, 2016 at 8:17 am
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...
November 15, 2016 at 8:16 am
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.
November 14, 2016 at 9:45 am
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...
October 28, 2016 at 9:08 am
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...
October 27, 2016 at 8:13 am
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....
January 20, 2016 at 4:57 am
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...
October 7, 2015 at 5:51 am
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...
October 5, 2015 at 6:17 am
Brilliant! Thank you very much indeed!
May 25, 2012 at 1:34 am
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...
September 1, 2011 at 8:43 am
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...
April 26, 2011 at 5:05 am
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...
April 8, 2011 at 7:05 am
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...
November 24, 2009 at 3:17 am
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...
November 23, 2009 at 7:15 am
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...
March 5, 2009 at 8:47 am