Viewing 15 posts - 421 through 435 (of 22,219 total)
Funny enough, the ChatGPT answer is pretty good, if not at all helpful. It's correct, the ANSI settings do affect plan generation. What it didn't bother to tell you was...
"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 10, 2023 at 2:22 pm
I've been in pain recently because of a niche topic and old information. I'm trying to migrate data into PostgreSQL through Azure IoT Hub. Troubleshooting stinks. Error messages are crap....
"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 10, 2023 at 2:15 pm
Yep. Pull first, then add stuff. You can't sync the two independently. One has to drive the other, especially initially.
"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 4, 2023 at 1:02 pm
So odd. Oh well. This is a hard win. Has been for a decade.
"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 3, 2023 at 4:37 pm
Sure. There's some overhead associated with this. It's probably not massive unless we're talking 10s of thousands of failed attempts. But without a doubt, yeah. Everything the server does, everything,...
"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 3, 2023 at 2:29 pm
Nah. If anything its me and the way I call out people's reluctance to embrace new stuff (that's actually functional and useful, not just new). I'm pretty sure I cross...
"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 2, 2023 at 3:06 pm
Of course they're not bad people. Just people. I see it all the time. It's perfectly normal, though a bit regrettable, behavior.
"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 2, 2023 at 2:35 pm
In a nutshell, they can do anything in the cloud (around VMs & AD I mean) that they can locally. There's no reason why it would just utterly fail 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
August 2, 2023 at 1:26 pm
Implicit transaction is always on. You can't turn it off. You're focusing on the wrong thing. The issue with deadlocks is a combination of performance and coding. From the performance...
"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 2, 2023 at 1:15 pm
I hate rebrands/renames. I think it creates confusion and often doesn't make anything better. Either you execute well or you do not and people know that, regardless of name.
However,...
"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 1, 2023 at 6:38 pm
And Extended Events.
Total agreement on DBATools.
"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 1, 2023 at 6:28 pm
You could look to Change Data Capture as a way to see all the data manipulation on the system. It does require quite a bit of setup & maintenance...
"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 1, 2023 at 12:34 pm
Honestly, look to a 3rd party monitoring solution.
Up front, being clear and open, I work for Redgate who makes a monitoring tool.
However, what you're trying for just isn't available, 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
July 28, 2023 at 12:35 pm
Damn Johan, great article. I missed that one.
"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 27, 2023 at 12:35 pm
You're not paranoid when they're out to get you. And they're out to get us.
"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 24, 2023 at 1:56 pm
Viewing 15 posts - 421 through 435 (of 22,219 total)