Viewing 15 posts - 3,841 through 3,855 (of 22,219 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
May 8, 2017 at 4:51 am
"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
May 5, 2017 at 11:47 am
"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
May 5, 2017 at 10:05 am
"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
May 5, 2017 at 8:50 am
I hate to say it, but I don't know that I want to get tied down to doing it the same way every time regardless.
I mean, for stored...
"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
May 5, 2017 at 7:55 am
You want to use the function sp_create_plan_guide. The basics are pretty simple. Copy your query, and it has to be a perfect copy, including all the white space...
"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
May 5, 2017 at 7:05 am
Actually one other thing does come to mind. You could try using Plan Guides to force the good plan. On a query this complex and a plan this big... 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
May 5, 2017 at 6:43 am
These queries are pretty huge. Trying to unpack it all will take a lot of time. I'll focus on one thing. Both plans are timing out in the optimizer. Timeouts...
"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
May 5, 2017 at 6:42 am
Linked servers are, unfortunately, a very widely used practice. They're not a very widely recommended practice because of all the issues that they cause. However, they're so very convenient, making...
"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
May 5, 2017 at 6:30 am
Which, it's worth noting, will rollback open transactions. Not the end of the world or anything, but worth noting.
"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
May 5, 2017 at 6:19 am
One additional point, lots of people talk about avoiding the nightmare scenarios of missing DBAs, etc., I joined my last company after an interview where the interviewer asked me what...
"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
May 3, 2017 at 8:06 am
Welcome to The Thread, Andy. If you're trying to read it all the way through...
"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
May 3, 2017 at 5:31 am
That's a decent list. You may not be able to ask all of them, but it's good to have a plan.
I'd ask about RTO & RPO, what they...
"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
April 27, 2017 at 5:19 pm
Yes. Absolutely. An application login using AD is correct. Further, that login should not be 'sa' on the server. It also shouldn't even be 'dbo' on the database. However, all...
"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
April 27, 2017 at 12:21 pm
Paul is one of the greatest. You'll probably never go wrong reading his stuff and following his advice.
The difference is in the amount of data being accessed. 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
April 27, 2017 at 12:18 pm
Viewing 15 posts - 3,841 through 3,855 (of 22,219 total)