Viewing 15 posts - 61 through 75 (of 22,227 total)
Damn those mynocks.
"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 17, 2025 at 12:21 pm
Rod, thanks for sharing that one. Great insight.
Chris. BWA-HA-HA. Sorry, probably shouldn't laugh.
"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 15, 2025 at 12:02 pm
Nice one Aaron. I've seen people try to make line count a measure. I told 'em straight up, I can make the line count go really, really high if necessary.
HA!...
"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 14, 2025 at 4:26 pm
Maybe I'm being pedantic, but I've never heard of a primary key index. As far as I know, you can make a table with a primary key that is...
"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 10, 2025 at 12:46 pm
I've seen all sorts of different setups. To my mind, there's not a single correct approach. It's down to understanding the architecture and where your bottlenecks are. Especially with a...
"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 9, 2025 at 12:19 pm
I know you fixed this already. Well done. However, figured I'd post this in case you, or anyone else, needs to hear it.
Databases are code.
They are. Yes, yes, the data...
"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:18 pm
Grant, I totally agree. It has served me well in my career to always own up to mistakes. Another developer I worked with always said it happens that sometimes...
"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:11 pm
Thanks for all the feedback everyone. For some reason it didn't show up in my email as per usual (I probably broke something).
"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:07 pm
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
Viewing 15 posts - 61 through 75 (of 22,227 total)