Viewing 15 posts - 421 through 435 (of 22,227 total)
Compile time values are also stored with the plan in the same place. When you look at plans with runtime values (aka, Actual Plans), you can also see the runtime...
"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 3:45 pm
I had to laugh, in painful sympathy, at that last sentence, Grant.
Ha!
And we can keep going. Don't let Jeff get started on fragmentation. Don't let me get started on...
"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 3:02 pm
Since those are estimated calculations, it's probably just some rounding errors that they didn't bother eliminating. But, I don't know the internals, so maybe I'm wrong.
"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:33 pm
And then test them through a restore process.
"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:32 pm
More, bigger, faster hardware. That's the deal. No other magic run faster switches for a restore operation... although in 2022 the recovery aspect of a restore is radically improved, so,...
"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:31 pm
No, it's a real error. However, the good/bad news is, you're dealing with tempdb. You can just drop and recreate it (with a reboot). Here's documentation on dealing with...
"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:29 pm
Failover will always include recovery. It has to. It's likely that the one that is going really slow simply has a lot more transactions to deal with.
"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:27 pm
I've got nothing, but I figured you should at least know that someone was looking. Sorry.
"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:26 pm
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
Viewing 15 posts - 421 through 435 (of 22,227 total)