There are two ways to change the MAXDOP value, within SSMS. How does that work?
Optimiser
Having been bitten by the delights of a Foreign Key(FK) with NOCHECK I thought it time to do a little digging. I’ve always been aware of the perils of this option but have encountered a table with this feature and I was caught out by it. I’m also aware of the impact it can have …
Notes on SQL 