# 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](https://twitter.com/janelle_coburn) during DataMishaps Nights conference.

{% embed url="<https://datamishapsnight.com>" %}

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

{% embed url="<https://twitter.com/kurianbenoy2/status/1497031795988074497>" %}

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.

{% embed url="<https://www.sqlshack.com/execution-plans-in-sql-server>" %}

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

{% embed url="<https://www.sommarskog.se/dynamic_sql.html>" %}

As my friend[@PaulAtkinsonPDX](https://twitter.com/PaulAtkinsonPDX)would 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#/>