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 Night
Data 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 Server
SQL 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:
Copy link