Check Constraints And Query Performance In SQL Server
Vložit
- čas přidán 5. 09. 2024
- Become a member! / @erikdarlingdata If you like what you see here, you'll love my advanced performance tuning training:
training.erikd... Click here for 50% off a health check: training.erikd...
I think I'm an expert in SQL Server and then I watch a video of yours and am humbled.
You’re not alone. I find myself humbled on a daily basis.
Amazing.. Hidden treasures of SQL by Erik
Aw, thank you!
Eric Darling, saving the world one wise query tip after another.
Hahaha, I sure hope so
Darling data class is the only class that youre not getting tired gracias maestro....
Hahaha, aw, thank you!
Amazing class sir
Thank you thank you thank you!
“Over-communicate to SQL Server” words to live by…
Hell yeah they are.
Thank you for the informative information.
Gotta stay informed!
I used to have constraints but now im uninhibited and i do all sorts of silly things.
Your dom must be pissed
@@ErikDarlingData She does not like this kind of tomfoolery
Got interested by your comments about not using constraint in data warehouse. Do you have other tips for Data Warehouses in general?
Column store, column store, column store.
If I don't laugh at my own jokes then who will?
Depends on who’s listening!
I definitely learned something new. Thanks. This constraint has a positive impact on query performance. But will it have a negative impact on INSERT, UPDATE operations? I think it's a trade-off.
Everything with databases is. There’s no such thing as a free feature.
Always learning new things. Thanks! What about not trusted constraints? Still helpful?
Helpful for what
@@ErikDarlingData for generating optimal plan
@@ErikDarlingData for generating optimal plan
@@ErikDarlingData in generating optimal plan. Does the engine use the constraint the same way if it's in untrusted mode?
@@bartimaeus1839 Oh, no, not in my experience.