A Very Silly Performance Tuning Trick In SQL Server
Vložit
- čas přidán 30. 05. 2024
- May I interest you in coming over to the Giggenbush with me?
If you like what you see here, you'll love my advanced performance tuning training:
training.erikdarling.com/?cou... - Věda a technologie
Here I am, fighting devs and report writers to never use VARCHAR(MAX) columns... :-) Party in the giggle-bush!
HAHAHA, yeah, same, same.
At least they’re not giving nvarchar parameters for varchar columns
@@ntobergta Alas, I see that too! Yesterday I found a column named "Years_In_Business." NUMERIC(10,2). So you have been operating since the end of the Mesozoic Era? Cool! The greatest value stored was 2016. I started looking longingly at my shelf of whisky bottles...
Thank you Erik! All the best!
Great Erik!
Well thank you 🥸
I honestly never thought I'd see that in my life hahahaha
Anyways, great insight, thanks!!
I like this short video! I like short videos. And I really look forward to your video on parallel nested loops. Then again, I might be a bit creepy.
Stay creepy my friend.
Great video 🎉
This is awesome, thankyou for sharing
Aw, glad you think so! Thanks for watching!
Thank you so much =)
This is a great comment.
Hahaha this is fantastic, thanks for sharing! Also… certs aren’t good you say? ACKSHUALLY my Crystal Reports 11 Certification from 2011 begs to differ. I use any chance I get to flaunt it.
Wow, I never would have guessed that there would be certifications for that. That's like getting a certification for FileZilla.
@@ErikDarlingData Indeed, I keep it next to my PAID winRAR cert :)
Ah, I have one of those for mIRC
LOL that and ICQ might make a comeback. You never know!
😂
:D