Viewing 15 posts - 196 through 210 (of 22,224 total)
Also, if a lot of code is generated, then the process of literally learning how to write that code is also going to be curtailed. Getting from junior to senior,...
"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 26, 2024 at 5:23 pm
Grant is right about the benefits of having interests outside of work and family. I am a member of the Tadley Men's Shed, and enjoy a lot of 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
August 26, 2024 at 12:17 pm
Grant, how did you find out about your local maker's faire? Is there an organization that tracks that sort of thing?
There is an organization in town that runs a...
"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 26, 2024 at 12:16 pm
. In practice it is very rare that a copy of Prod, even when scrambled, will be adequate for the needs of Dev.
I find that prod data 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
August 19, 2024 at 6:37 pm
I've never used it, especially not in anger, so I've got nothing. However, I've reached out to see if I can get someone over here to help out.
"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 13, 2024 at 12:07 pm
Your state may already have a law about it. I was just talking to the IT staff of another state and they had one. I think most states do. But...
"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 12, 2024 at 6:05 pm
There I was, with a written, thank the gods, command, "Whenever a developer asks for a copy of production, give it to them."
A developer asked and I hooked him up.
Said...
"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 12, 2024 at 3:59 pm
Thank you all for the feedback and comments.
I would like to point out that I did emphasize "collectively" we stink. Individually, there were people running Crowdstrike on Windows who weren't...
"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, 2024 at 12:27 pm
Think of it as a toggle. Instead of off to on, it's like to unlike. So you hit like, it marks it as a like, but changes it to unlike...
"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 26, 2024 at 2:18 pm
They are pretty desperate to make this not about them. It isn't... but it also 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
July 22, 2024 at 7:11 pm
So, did anyone here get burned by the Cloudstrike debacle Friday?
Steve, Ryan and I were traveling on Friday. It was a mess, but Steve and I made it home....
"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 22, 2024 at 4:06 pm
Unless you have some kind of direct evidence that anything is causing a problem, leave it alone. Don't kill sessions without knowledge of there being an issue.
"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 18, 2024 at 1:16 pm
There isn't a single correct answer to this. Here's my list of "I'm gonna need this" software:
SQL Server Management Studio
Azure Data Studio
VS Code
Git
Docker
Redgate Toolbelt (yes, I work for them, but...
"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 15, 2024 at 1:56 pm
If you really want performance, create a wrapper proc that determines if you're doing an INSERT/UPDATE/DELETE and then a proc for each. MERGE generally stinks on performance. Period.
"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 12, 2024 at 12:44 pm
Happens to everyone. No worries.
"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 11, 2024 at 4:04 pm
Viewing 15 posts - 196 through 210 (of 22,224 total)