Viewing 15 posts - 2,356 through 2,370 (of 22,214 total)
Get and compare the execution plans for the two queries. That's your best bet when the question "What's happening with this query" comes up.
Also, why XML for an existence check?...
September 11, 2019 at 11:53 am
It could be any number of things. The port is blocked for them. The DNS doesn't recognize the name. The IP address is wrong. Wrong password (sql login, which it...
September 11, 2019 at 11:49 am
For some reason, I'm not seeing a "report" link on this post. Can someone report it for me?
https://www.sqlservercentral.com/forums/topic/editing-a-post#post-3678729
Did one better and just marked it as spam.
September 10, 2019 at 2:36 pm
Please tell me you're not lying on your CV.
OK, here's a real world experience that represented a challenge to me. You can use this on your next interview to explain...
September 10, 2019 at 12:54 pm
You've moved out of my core knowledge. I agree that you've proven it's related to the CPU and therefore to the VMs management of it. Good luck getting the people...
September 9, 2019 at 10:52 am
Every single time I hear "Performance is different, but everything is the same" it always comes around to things not being the same. Don't focus on the code. Focus on...
September 6, 2019 at 8:58 am
If you're not working on administrative tasks, then you can do most of the work of development in any of the three environments. The core behaviors are identical. And SQL...
September 6, 2019 at 7:48 am
Good luck. I'm pretty ignorant on the VMWare front as well. Nice to find out what changed though.
September 6, 2019 at 7:40 am
There has to be difference of some kind. Always. If the plans are absolutely identical (and please, not just the graphics are the same, the data behind it is the...
September 4, 2019 at 4:06 pm
One of the things to try :
if it works fine with maxdop 1, enable QueryStore if it's not enabled yet, get fast plan captured in it and force the...
September 4, 2019 at 12:18 pm
The execution plan stays the same between MaxDop 1 and other settings? Cause overall, I'd say you crossed a threshold on row counts. That's when I've seen things go south....
September 4, 2019 at 8:28 am
The Visual Studio query editing environment is largely, but not perfectly, the same as writing it in SSMS. The core behaviors are the same. I'd say that people who work...
September 4, 2019 at 8:22 am
Is the database in full recovery mode? Do you have log backups running? How often are the log backups running? The log file is just your transactions, cumulative, so it's...
September 3, 2019 at 9:16 am
I really don't know. I think getting the EF code changed is your best bet.
September 3, 2019 at 5:43 am
Not one I've run into before, but I think it's the LIKE. I'm not sure why, but it must not be able to parse that type of command. I ran...
September 2, 2019 at 2:24 pm
Viewing 15 posts - 2,356 through 2,370 (of 22,214 total)