Viewing 15 posts - 406 through 420 (of 22,232 total)
Thanks for the comments. Sorry I haven't gotten back. I was on vacation.
And yeah, I'm assuming a bug-in scenario more than a but-out one. However, set for both if necessary.
"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 5, 2023 at 12:33 pm
Hey Brandy,
Another vote for getting them to go with read_uncommitted. When they realize they've dug a hole, let 'em out easy.
And welcome back!
"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 23, 2023 at 2:35 pm
Here you go. You can see the allocated & unallocated space.
Frequently, log growth is because you either don't have log backups enabled while in full recovery, or you don'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
August 23, 2023 at 12:13 pm
Once a file size is allocated within SQL Server, it stays allocated. You can delete every bit of data from a 5tb data file, and the data file will still...
"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 23, 2023 at 12:08 pm
I made a boo boo and reported a wrong post.
Steve/Grant/Webmaster - could you please reinstate post 4268917 on this thread?
https://www.sqlservercentral.com/forums/topic/logical-consistency-based-i-o-error-for-tempdb-ndf
Thanks muchly
Done!
"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 23, 2023 at 11:54 am
Fixed the accidental spam.
"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 23, 2023 at 11:54 am
Maybe. It depends on the demands of the app and if it can use the newer version. In some instances, yes, you'll be able to just uninstall 17 and 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 22, 2023 at 4:04 pm
An execution plan is your best friend when it comes to understanding what's happening on a query like this, especially after you change it.
"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 22, 2023 at 4:02 pm
GRANT WITH GRANT
What?
"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 22, 2023 at 3:59 pm
Might want to listen to what @Ant-Green is saying on this 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
August 21, 2023 at 12:28 pm
The broader the key, the more likely an index is to fragment. More keys, more fragmentation. Overall though, I'd only worry about fragmentation if you can prove, and I mean...
"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 18, 2023 at 3:00 pm
The broader the key, the more likely an index is to fragment. More keys, more fragmentation. Overall though, I'd only worry about fragmentation if you can prove, and I mean...
"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 18, 2023 at 3:00 pm
Yeah, a lot more data is needed here. What command were you running? Which version of SQL Server? I do not recognize this message, so I'm unsure what to do.
Based...
"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 18, 2023 at 2:58 pm
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
Viewing 15 posts - 406 through 420 (of 22,232 total)