Performance Pains with NOT IN and Nullable Columns

Erik Darling has a video.

Erik has had many great videos, though not enough text for me to copy and paste. Nonetheless, I consider it a civic duty to remind people once in a while that Erik consistently puts out great content and you should watch his videos.