Viewing 15 posts - 91 through 105 (of 22,219 total)
The difference between a junior dev generating 95% of their code in AI and a senior dev generating 95% of their code in AI is that the senior dev...
"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
April 15, 2025 at 2:51 pm
Call me a dinosaur if you like, but I'm 100% with Alex Gay - don't use it and wouldn't use it for code I can write myself. Nearest 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
April 15, 2025 at 2:48 pm
You'll notice that none of those plans have a check mark, meaning, they're forced. So, what's likely is that the machine learning algorithm doesn't see a significant difference in execution...
"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
April 15, 2025 at 2:24 pm
I don't have a measured number, but I'd guess at the moment, 60% or so of my code is initiated in an AI. It's a fantastic short hand to 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
April 14, 2025 at 3:12 pm
I'd most want to see the execution plans before & after if you can get them. That's going to give you the most understanding of what is happening. From 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
April 14, 2025 at 3:09 pm
I'm not aware of anything that could do this.
You might try, strictly experimentally, feeding the code into an AI engine and seeing if you can build a prompt that will...
"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
March 6, 2025 at 1:58 pm
Reviving 10 year old zombie threads should probably be a no-no.
"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
March 4, 2025 at 1:48 pm
Oh wow man. That's harrowing, at best. Fingers crossed for you and Trigg both.
And database triggers (mostly) suck.
"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
February 24, 2025 at 10:05 am
Is there any circumstances where you would allow code with a 'SELECT * ' to go into production?
I believe this should NEVER happen. There is a discussion that some...
"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
February 21, 2025 at 8:11 pm
Congratulations @jeff-moden Finally overtook the high priestess on the SSC overall leaderboard.
She did have a shedload of LIKEs. The "upgrade" on the site years ago hasn't helped much...
"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
February 21, 2025 at 8:04 pm
My dad was a Mergenthaler Lin-O-Type operator. He set type for decades. I learned about etaoin shrdlu from him probably more than 70 years ago.
He had a favorite trick...
"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
February 21, 2025 at 1:31 pm
Strong suggestion, don't store the images in the database. Can you? Yes. VARBINARY(MAX) would be the way to go. However, it really negatively impacts a whole slew of things from...
"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
February 20, 2025 at 2:11 pm
It's a VM and operates like a VM. Attached storage will act like attached storage. I'm not sure where you're going with this. As I said before. It's going 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
February 17, 2025 at 7:05 pm
Right there with you Jeff & Andrew. Stuff like this makes so many things more difficult.
"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
February 17, 2025 at 2:15 pm
Agreed. When we start reaching a limit, we should reconsider the approach. I can only assume someone needing that many parameters is trying to process a lot of 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
February 17, 2025 at 2:12 pm
Viewing 15 posts - 91 through 105 (of 22,219 total)