Viewing 15 posts - 31 through 45 (of 5,842 total)
February 6, 2018 at 9:41 am
February 6, 2018 at 8:03 am
I submit it is not guesswork (assuming no server load/blocking issues). It is what I call the "widely-varying-input" problem. Pay attention to that I am about to say, because it...
February 5, 2018 at 9:19 am
Thanks for the feedback. Yeah... I agree. 3rd party stuff can be...
February 5, 2018 at 8:09 am
Lynn Pettis - Friday, February 2, 2018 7:58 AMI would NOT use ssms maintenance plans.
NOT EVER - FOR ANY REASON!!!!!!!!! ...
February 2, 2018 at 8:45 am
Has anyone tried my suggestion of CASTing EVERYTHING to (n)varchar(max)? I have used explicit CASTing of pretty much everything for a long time to avoid any such issues (string and...
February 1, 2018 at 6:47 am
February 1, 2018 at 6:44 am
today my server is fail overeed and restarted automatically
as per error logs i found...
January 31, 2018 at 8:36 pm
January 30, 2018 at 9:10 pm
Well, if it isn't causing user complaints I don't know that I would worry too much.
Are you using sp_whoisactive (with some parameters enabled) to do your investigation?
January 30, 2018 at 9:07 pm
January 30, 2018 at 12:44 pm
Request 2: please save both query plans off as files and do a text-based comparison of them. My suspicion, as I bet yours since I know you know SQL Server...
January 30, 2018 at 12:43 pm
Before I read any further, did you try running this via sqlcmd in a batch file?
January 30, 2018 at 12:40 pm
Viewing 15 posts - 31 through 45 (of 5,842 total)