Viewing 15 posts - 106 through 120 (of 22,227 total)
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
2100 parameters for a sproc? If you think that is a problem, you have far larger real problems.
Ha! Yeah, no kidding. However, someone, with a bunch of money, went...
"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:11 pm
Your best bet is to use the Azure Pricing Calculator or directly contact support. And remember, it's not just storage costs. Are you moving data OUT of Azure? 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
February 5, 2025 at 1:08 pm
Export, backup, whatever. It's going to look & act like a drive inside the VM.
"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
January 27, 2025 at 12:36 pm
If you create a container inside your storage account, you can then use the mount command to mount it as NFS storage inside the VM.
Something like this (example code 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
January 15, 2025 at 1:19 pm
I couldn't agree more about being prepared ahead of time. When I read your post, what immediately came to mind were two words: Crowdstrike 🙂 That horrible morning...
"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
January 14, 2025 at 5:07 pm
Grant Fritchey wrote:The universe is actively out to get us.
This made me laugh.
It's not paranoia if it's true, right!? 😉
Exactly.
"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
January 13, 2025 at 8:42 pm
There's a connection to the database. That's what that error is telling you. I'll bet money it's SSMS. However, to find out, just open a query window, not connected 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
January 13, 2025 at 3:51 pm
Viewing 15 posts - 106 through 120 (of 22,227 total)