WITH NO EXCEPT
PreviousHandling Database disconnects in SQLAlchemyNextWhat is difference with JSON documents in postgres and Mongodb
Last updated
Was this helpful?
Last updated
Was this helpful?
Using WITH NO EXCEPT is an intermediate SQL concept to control resource to run(damn I forgot what it was). This was introduced by during DataMishaps Nights conference.
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.
One last resource - I have seen Erland speak and I particularly like this article (but he has more)
As my friendwould 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:
