Viewing 15 posts - 1,696 through 1,710 (of 22,232 total)
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
I assume we're talking about a batch here with multiple statements?
In that case, put Extended Events to work. You can create a session using the sql_statement_completed event for batches, or...
"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:31 am
Nah, interrupt sounds fine. Ha! I'll see what I can do to get that fixed.
BTW, 3rd edition is WAY better than the first two.
"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 28, 2020 at 2:20 pm
Changes to the connection strings? ANSI settings? Differences in compiled execution plans? As above, wait statistics?
These are just a few of the possibilities. Also, you running a batch versus your...
"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 28, 2020 at 12:10 pm
Tons of stuff is faster in 2017. You should see what happened with 2019. They improved all sorts of stuff even more. It's honestly insane just how much better 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
July 28, 2020 at 12:07 pm
OK. So, with ColNumber as the primary means of accessing the data, probably, and you should test this, not just trust some yahoo on the internet, that's your clustered key...
"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 28, 2020 at 10:40 am
Okay, maybe I misunderstood the OP, but I thought from their explanation of the problem that they were trying to use the TOP clause to only get part of...
"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 23, 2020 at 2:03 pm
A stored proc would just use the script you have. It'll work.
"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 23, 2020 at 2:03 pm
Viewing 15 posts - 1,696 through 1,710 (of 22,232 total)