Viewing 15 posts - 2,356 through 2,370 (of 22,219 total)
Hmmm... I wonder if the new Cardinality Estimator would actually do a better job at this?
Not sure, but if I get the time to try this out, it will...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 12, 2019 at 12:41 pm
Because the filter has to be applied to the XML itself. The way the query is written, you're filtering on the aggregation and aggregation occurs within the XML. So you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 12, 2019 at 11:33 am
Yeah, first time I've seen this kind of filtering done against an XML result set. It actually worked WAY better than I would have imagined.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 11, 2019 at 9:31 pm
I think you're giving me WAY too much credit on this one Jeff. Let me look the plans over...
I'm not sure.
I assume that the EXISTS operator must be pushing down...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 11, 2019 at 6:37 pm
If you can post the plans, do that (SentryOne Plan Explorer can make them anonymous).
It's likely that Jeff has nailed it (Jeff is right a lot). Most of the time,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 11, 2019 at 4:29 pm
The ping command is your buddy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 11, 2019 at 11:54 am
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?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 4, 2019 at 4:06 pm
Viewing 15 posts - 2,356 through 2,370 (of 22,219 total)