Viewing 15 posts - 1,681 through 1,695 (of 22,224 total)
"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
August 4, 2020 at 4:49 pm
And another. Cleaning up tabs.
"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
August 4, 2020 at 3:23 pm
"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
August 4, 2020 at 3:22 pm
"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
August 4, 2020 at 3:22 pm
Are they part of larger batches? There could be multiple statements involved.
"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
August 4, 2020 at 1:56 pm
Adding NOLOCK here, or almost anywhere, is a bad idea.
Look, if you really want to have dirty reads, change your connection string to use READ_UNCOMMITTED. That's the same as NOLOCK,...
"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
August 4, 2020 at 11:37 am
You've identified some queries, but now you need to investigate their behavior within the system. The way to do this is to look at the execution plan in order to...
"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
August 4, 2020 at 11:35 am
Thank you for those posts Grant. It helps to try and reset your view when there's so much going on that can drain us emotionally right now. I'm not...
"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
August 3, 2020 at 6:26 pm
GOOD MORNING GRANT!!!!
I recently saw an article about "Self-made men" and it expresses exactly the way I feel. To summarize, I'm definitely not "self-made". I'm where I'm at because...
"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
August 3, 2020 at 6:25 pm
Very kind words. Thanks.
"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
August 3, 2020 at 11:01 am
Yeah, the curse and blessing of capturing the queries is you get to see exactly what's going on. Little things like that 19,700 executions accumulate in an insane manner to...
"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
July 31, 2020 at 10:40 am
File... Open.
That's it. It's really straight forward.
"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
July 30, 2020 at 2:48 pm
No. You should be able to open a live file. I do it all the time.
Oh wait, I see what you said. If you want to aggregate, you do have...
"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
July 30, 2020 at 2:27 pm
There are three ways to access the data in Extended Events. You can use the Live Data window within SSMS. It works really well and has a lot of functionality...
"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
July 30, 2020 at 11:58 am
Which tables are these from:
and DTMTRADEDATE='2020-07-28'
and STRSALETYPE in ('I','W')
If those columns are in any of the tables where you're doing a LEFT JOIN, you should move these...
"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
July 29, 2020 at 11:34 am
Viewing 15 posts - 1,681 through 1,695 (of 22,224 total)