Performance Tuning Semi and Anti-Semi Joins In SQL Server

[@stephenlawrenson2380]

I thought “salt licker” was an insult over that side of the pond!!

[@ErikDarlingData]

perhaps it's a mad cow thing?

[@AndrzejPauli]

What are You talking about: Your appearance on green screen is simply GR-8! 🙂

[@ErikDarlingData]

ha ha, thanks! i ought to do the weather.

[@FlaggedStar]

I wish that more people knew about semi-joins. They're such a useful tool for thinking about problems that I wish that they were in the language itself. I worry when a DBA has never heard the term. It means they're missing a tool in their toolbox.

[@ErikDarlingData]

I would wonder how they managed to become a DBA without ever having heard the term before, but alas…

[@GroterRonald]

That was a nice one, thank you. (By the way .. they *all* are nice!)

[@ErikDarlingData]

Aw, thank you! 😊

[@caparn100]

Very interesting, what database are you using for your testing? Is it stack exchange?

[@ErikDarlingData]

Yes, StackOverflow2013.

[@douglascoats7081]

I didnt know you were a horse

[@ErikDarlingData]

That’s because I only appear from the waist up.

[@douglascoats7081]

@@ErikDarlingData omg youre a centaur?!?!!!!!????

[@ErikDarlingData]

Technically a taur mix but close enough