Viewing 15 posts - 61 through 75 (of 22,219 total)
You're not paranoid if they really are out to get you.
And they are.
"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 8, 2025 at 1:04 pm
Well, the Oracle DBA left for various reasons and I got tapped to ALSO manage and maintain Oracle (they're both databases, how hard could it be?)
Oh, ouch.
"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 2, 2025 at 11:08 am
I think a view with an ORDER BY needs TOP in the SELECT.
Also, selecting from a view with an ORDER BY does not guarantee order of the result. An...
"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 1, 2025 at 11:53 am
If you're running in Azure SQL Database, there are two mechanisms that can allow you to set up a read only secondary that you can then point the AI 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
July 1, 2025 at 11:40 am
How are you measuring the duration and getting the average? DMVs, Query Store, Extended Events?
Is it linear?
"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
June 12, 2025 at 2:07 pm
I agree. It would have to be an added column on a given table that states the source of the data. You could create a user-defined-type using ENUM for the...
"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
June 12, 2025 at 2:06 pm
Something like this would do it:
WITH datebreakdown
AS (SELECT DATEPART(hh, sod.ModifiedDate) AS hourval,
DATEPART(mi, sod.ModifiedDate) AS minval,
...
"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
June 10, 2025 at 12:45 pm
I'm pretty sure every union on the planet would lose their minds over what my job entails. The number of weekends that just go away. Holidays I don't get. Crazy...
"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
June 4, 2025 at 1:29 pm
How do you control production deployments without source control? How can you be sure that the code that was tested is what gets deployed? In our world, nothing gets...
"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
May 22, 2025 at 11:48 pm
"It's a pull because you're asking someone to accept your code. You pushed it into the Pull Request, but they don't have to take it. They have to pull...
"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
May 22, 2025 at 12:32 pm
You can. However, it's work to get it set up well so you get the info you want without putting too much load on the system.
Extended Events has a thing...
"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
May 22, 2025 at 12:30 pm
I see your point, Grant. I hesitate because I saw what happened when we had TFS on-prem. My employer is so dead set against spending any money that when...
"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
May 22, 2025 at 11:32 am
Rod, they could set up a central Git server, no cost at all, locally and then use that. It's going to be all command line driven (although I'm sure there's...
"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
May 21, 2025 at 2:50 pm
I can't imagine working without source control. It's like boxing with one hand tied behind your back.
Yeah, in all seriousness, I can't imagine not using it. Heck, I use...
"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
May 21, 2025 at 2:47 pm
Strong suggestion, don't use Profiler. The GUI puts considerable load on a server. Trace Events, the underlying technology, aren't all that kind to a server either. Instead, use Extended Events.
Also,...
"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
May 21, 2025 at 2:46 pm
Viewing 15 posts - 61 through 75 (of 22,219 total)