Check Constraints And Query Performance In SQL Server

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...

[@ScorpionJL]

I think I'm an expert in SQL Server and then I watch a video of yours and am humbled.

[@ErikDarlingData]

You’re not alone. I find myself humbled on a daily basis.

[@ArunnGupta]

Amazing.. Hidden treasures of SQL by Erik

[@ErikDarlingData]

Aw, thank you!

[@alexandermayerkirstein]

Eric Darling, saving the world one wise query tip after another.

[@ErikDarlingData]

Hahaha, I sure hope so

[@mortezasafaee6981]

Darling data class is the only class that youre not getting tired gracias maestro....

[@ErikDarlingData]

Hahaha, aw, thank you!

[@Devanshu_Maurya]

Amazing class sir

[@ErikDarlingData]

Thank you thank you thank you!

[@alexandermayerkirstein]

“Over-communicate to SQL Server” words to live by…

[@ErikDarlingData]

Hell yeah they are.

[@mohsensayadian]

Thank you for the informative information.

[@ErikDarlingData]

Gotta stay informed!

[@douglascoats7081]

I used to have constraints but now im uninhibited and i do all sorts of silly things.

[@ErikDarlingData]

Your dom must be pissed

[@douglascoats7081]

@@ErikDarlingData She does not like this kind of tomfoolery

[@MathieuDaigle]

Got interested by your comments about not using constraint in data warehouse. Do you have other tips for Data Warehouses in general?

[@ErikDarlingData]

Column store, column store, column store.

[@Variant55]

If I don't laugh at my own jokes then who will?

[@ErikDarlingData]

Depends on who’s listening!

[@marancibia1971]

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.

[@ErikDarlingData]

Everything with databases is. There’s no such thing as a free feature.

[@bartimaeus1839]

Always learning new things. Thanks! What about not trusted constraints? Still helpful?

[@ErikDarlingData]

Helpful for what

[@bartimaeus1839]

@@ErikDarlingData for generating optimal plan

[@bartimaeus1839]

@@ErikDarlingData for generating optimal plan

[@bartimaeus1839]

@@ErikDarlingData in generating optimal plan. Does the engine use the constraint the same way if it's in untrusted mode?

[@ErikDarlingData]

@@bartimaeus1839 Oh, no, not in my experience.