Viewing 15 posts - 151 through 165 (of 22,232 total)
Generally speaking, it all goes through one person, Steve Jones. I don't think he has a team checking things out like that.
"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
December 10, 2024 at 2:29 pm
SQL Server is not going to be able to validate duplicate documents. It just doesn't work like that. Maybe with SQL Server 2025 and the new AI functionality, but even...
"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
December 6, 2024 at 1:04 pm
Just what you say. Capture query metrics with Trace (and you have no idea how painful that was for me to type, #TeamXE) to see which ones are using CPU....
"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
December 6, 2024 at 1:01 pm
Multiple posts on the same topic just confuses things. Let's keep the discussion on this, over here at the link. Thanks!
"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
December 6, 2024 at 12:57 pm
It is possible we're losing value, on average. We are starting to age out of this position and more junior people are taking it on. Plus, lots of younger people...
"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
December 5, 2024 at 9:31 pm
Grant Fritchey wrote:Just know that moving data OUT of Azure costs money.
I thought just LOOKING at Azure cost money! @=)
Oh, it's not that bad. They'll let you look. Just get...
"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
December 5, 2024 at 9:29 pm
Ooh, I so feel this.
One I see all the time, and I'm sure you do too, is when traveling internationally, depending on your flights, blah, blah, blah, you end up...
"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
November 27, 2024 at 2:20 pm
Generally, it'll cause CHECKDB to fail. However, I've seen it where it takes the server offline. This is because the rollback that has to occur, also needs some disk space,...
"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
November 27, 2024 at 2:14 pm
Migrating between data platforms is a massive undertaking. It's not just data types, although that's a big part of it. You also have to take into account connection mechanisms within...
"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
November 27, 2024 at 2:13 pm
Just know that moving data OUT of Azure costs money.
"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
November 25, 2024 at 2:22 pm
Couple of things. It's now maintaining an index in addition to simply dumping data into a heap. Also, depending on how your data is ordered on retrieval, you may be...
"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
November 25, 2024 at 2:21 pm
You deserve a lot of credit for bringing people, quite literally, to the table to talk. Well done.
And thank you for all your help over the last couple of years.
"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
November 25, 2024 at 2:19 pm
The size of your log backups over time are a very good indicator as to how much stuff is passing through the logs.
"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
November 19, 2024 at 4:08 pm
Yeah, you do have to take care of yourself. Otherwise things get rocky. And happy to help anywhere I 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
November 18, 2024 at 3:19 pm
Since you don't need realtime, the cheapest and easiest way will be backup and restore. Nothing to 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
November 15, 2024 at 3:35 pm
Viewing 15 posts - 151 through 165 (of 22,232 total)