Viewing 15 posts - 2,356 through 2,370 (of 22,227 total)
SSMS is a separate install, too.
YAY!!!
"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 25, 2019 at 1:35 pm
Do you have a limit on the number of processors in use on the server? You really should, but if it's set to 0, then SQL Server is making 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 25, 2019 at 1:34 pm
I think there's a Stairway series on them here on SSC.
"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 24, 2019 at 5:11 pm
Fill factor determines the amount of free space in a page. Generally, this alone, isn't determining query performance. You may be seeing additional I/O because you have a very low...
"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 24, 2019 at 10:29 am
Replication is a viable for this situation. However, I shy away from replication very hard because it has received zero love from Microsoft for well over a decade. It's just...
"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 24, 2019 at 10:25 am
Determining the cost threshold can be hard. However, I have a blog post that uses your own queries as a mechanism for making that choice. Suffice to say, 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 24, 2019 at 10:20 am
Grant: "The other is the need to filter after the XML is put together."
Do you mean that it materializes the ENTIRE resultset into one giant XML construct, and then...
"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 13, 2019 at 12:19 pm
Fingers crossed, this adds a little light and no more heat...
From a strictly performance oriented approach, I'm 100% with Gail. Integers are better. Period. Therefore, when performance really counts, I...
"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 13, 2019 at 12:17 pm
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
Viewing 15 posts - 2,356 through 2,370 (of 22,227 total)