WITH NO EXCEPT

Using WITH NO EXCEPT is an intermediate SQL concept to control resource to run(damn I forgot what it was). This was introduced by Janelle Coburn during DataMishaps Nights conference.

Data Mishaps NightData Mishaps Night

I asked Janelle Coburn via tweet about how to learn some of the intermediate topics in SQL.

Here reply can be found here:

SQL Shack has some good stuff, I feel like so much of what I've learned is through trial and error (since I'm not a DBA but I've played one on TV sometimes). I would recommend checking out indexes, and query plans.

Execution Plans in SQL ServerSQL Shack - articles about database auditing, server performance, data recovery, and more

One last resource - I have seen Erland speak and I particularly like this article (but he has more)

The Curse and Blessings of Dynamic SQL

As my friend@PaulAtkinsonPDXwould say, WITH (NOLOCK) isn't a good idea except for when it's a good idea so it needs to be used for a reason. There are some good talks here:

https://passdatacommunitysummit.com/sessions#/