Viewing 15 posts - 2,071 through 2,085 (of 22,224 total)
Me too. I got the question right through the process of elimination, not knowledge.
"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
January 28, 2020 at 2:33 pm
There are many different scheduling services within Azure. Find one of them and put it to 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
January 28, 2020 at 1:39 pm
Filtering on your extended events would be the biggest boost. Don't capture what you don't need. Most stringent filters first in order (maximizes the reduction in overhead).
"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
January 28, 2020 at 1:38 pm
If it has gone from minutes to days, that is highly abnormal. I'd suggest stopping that process. Disable it for the moment. Then, I would run each of the "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 28, 2020 at 1:36 pm
There. Cleared it up.
"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
January 28, 2020 at 1:22 pm
I'm on 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
January 28, 2020 at 1:11 pm
Excellent! Good to hear it.
Best of luck on the GitHub integration.
"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
January 27, 2020 at 11:11 pm
I'm going to state this the best way I can:
I don't know enough about automating Git to help you. Sorry. You're just beyond what I'm comfortable with there.
The automation 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
January 27, 2020 at 7:22 pm
All those functions on the columns, LEFT/RIGHT, that's horrible. Before we get to why all the INTERSECT & UNION from the generated code, that stuff is going to inflict pain....
"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
January 27, 2020 at 7:12 pm
I've been blogging about it a bunch over at scarydba.com.
I have a bit of a screed coming out on it next week.
My argument is simple. Anyone operating on 2012 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
January 27, 2020 at 4:11 pm
Probably ought to report that to Microsoft. They've got an aggressive releases so they could get a fix in.
"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
January 27, 2020 at 3:19 pm
...I talked about using profiler...
<sigh>
You're killing me here.
"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
January 27, 2020 at 3:08 pm
The problem i face is with things like blog is my lack of knowledge and experience.
I feel like everything i know has already been written somewhere by someone already.
Yep....
"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
January 27, 2020 at 3:07 pm
If you have specific questions, never hesitate. We try to be helpful here. If we can help someone get a job or an employer get a good DBA, all 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
January 27, 2020 at 1:31 pm
It's not just a seek versus a scan issue here. There are a whole slew of differences between these two queries, even though it looks like the result sets are...
"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
January 27, 2020 at 12:56 pm
Viewing 15 posts - 2,071 through 2,085 (of 22,224 total)