Viewing 15 posts - 781 through 795 (of 22,219 total)
So, you're going for a swim in the deep end of the pool.
Let's start with what you shouldn't do. Don't rebuild the indexes. Probably, they hit issues in the past,...
"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 20, 2022 at 1:15 pm
Although, if you move that part of the WHERE clause to the ON clause, you should still get an outer join.
"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 20, 2022 at 12:45 pm
Really hoping they don't mangle the B5 reboot.
From your keyboard to the ears of the gods.
"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 20, 2022 at 12:16 pm
Absolutely "Babylon 5" was and is the best does not mean I watch any other science fiction fantasy if I can get my hands on it! I happen 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
September 19, 2022 at 10:17 am
Yeah, plan forcing will translate. Automated tuning won't. It will have to "relearn" the automated tuning stuff. Also doesn't survive reboots.
"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 19, 2022 at 8:23 am
Yeah, I know that one. 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
September 18, 2022 at 12:07 pm
I want more of B5... for work I would like those that don't understand the technology would include and listen to those that do in their discussions.
Oh, I've got...
"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 17, 2022 at 3:07 pm
I can hear the questions asked in the voices of the characters. Thank you for the nostalgia!
I agree as well with what you wrote. Sure, I make most 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
September 17, 2022 at 3:04 pm
Read this to my daughter, who I brought up watching the show, she wants to know which episode it was? Thanks Runa.
"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 17, 2022 at 3:04 pm
Who are you? What do you want? Do you have anything worth living for?
When Babylon 5 was in its second season, I attended a Science Fiction convention in Ohio...
"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 17, 2022 at 3:03 pm
Yeah, Kevin is great at this stuff too.
"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 15, 2022 at 6:22 pm
It is an older book, but this one by Itzik Ben-Gan is simply one of the best for learning T-SQL.
"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 15, 2022 at 1:42 pm
Just bear in mind that if you sit in the front row you are regarded as a righteous kill.
You can sit in the back. Won't matter. Buck will spot...
"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 15, 2022 at 12:35 pm
larry.blake wrote:Grant does a great job of presenting both Redgate and non-Redgate topics btw.
Cheers!
Very kind of you to say. Could you share it with my boss? Ha!
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 14, 2022 at 4:43 pm
Grant does a great job of presenting both Redgate and non-Redgate topics btw.
Cheers!
Very kind of you to say. Could you share it with my boss? Ha!
"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 14, 2022 at 2:51 pm
Viewing 15 posts - 781 through 795 (of 22,219 total)