Viewing 15 posts - 406 through 420 (of 22,219 total)
Or, have the job query a table for the parameter values and then give yourself permission to edit those. Not ideal, certainly, and a lot more work, but it does...
"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 16, 2023 at 4:58 pm
You might be able to do this programmatically through GitHub actions or workflows. I haven't done this, so I'm a little unsure what would be best.
Generally, even when branching...
"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 15, 2023 at 4:51 pm
Generally, we would create a group within Windows security, give that group access to the database, then add or remove users from the group. That way, we didn't have 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 14, 2023 at 1:00 pm
The SQL Server service is what manages the databases, so yes, if that is appropriately in place, you should be able to connect to the database.
"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 14, 2023 at 12:57 pm
I do radio as a hobby (yeah, I know, I'm worse than a cross-fitter, I won't shut up about it). The fun thing about the hobby is that you can...
"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 11, 2023 at 12:51 pm
Oh, that stinks. So 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 10:55 pm
Times... meh. Especially a single run can be affected by so many things.
If you're getting different execution plans for the same query, it really is either parameter values, implying 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
August 10, 2023 at 3:54 pm
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
Viewing 15 posts - 406 through 420 (of 22,219 total)