Viewing 15 posts - 796 through 810 (of 22,224 total)
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
I clearly have biases. When I'm not talking about a pure, non-Redgate, topic, in short, stuff that can be construed as marketing or sales, I just try to be incredibly...
"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 12:45 pm
Ooh, I would not solve this by going to VARCHAR(MAX). That could cause all sorts of performance problems. If you really have to go through this exercise, the answer is...
"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 12:38 pm
It can't be turned on with the secondary in 2019 or less (2022 only). When the primary fails over, it will have Query Store and the last good plan enabled...
"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 11:56 am
The suspended state just means it's a connection waiting for a query to run. It's not actively using resources (well, a tiny amount of memory maintaining the connection). Did 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 13, 2022 at 5:59 pm
Nah, you can turn off whatever you want. You'll lose some pretty sophisticated SQL Injection protection and a few other things.
I was referencing Query Store and ExEvents as a way...
"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 13, 2022 at 5:48 pm
Then walk through all other roles and groups that the login is associated with. Something has gone south.
"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 13, 2022 at 2:35 pm
Not much data to go on, but that looks like a pretty benign thing. It's had 3 seconds of waits over however long it's been connected (can't see that 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
September 13, 2022 at 12:42 pm
Also, you sometimes see this kind of thing when thresholds are crossed such that the row counts change and different execution plans get generated. Over time, statistics and data distribution...
"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 13, 2022 at 12:36 pm
Take a look above at the "Stairways" menu choice. Inside there are tons of classes, including several on T-SQL fundamentals. They're 100% free. Go 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
September 13, 2022 at 12:33 pm
Just for clarification, each execution plan is only, ever, for a given query. Sure, a batch or procedure might have 50 queries, but there will be 50, individual, execution plans...
"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 13, 2022 at 12:31 pm
Viewing 15 posts - 796 through 810 (of 22,224 total)