Thanks for this thread - we were having the exact same problem and this has really helped us get to the bottom of this issue

• SQL 2016 SP3
• intermittent "Cannot...

I understood that the question was about philosophy of using positive or negative for the attribute names

This naming convention if should it be X, IsX, DoILikeX or X_Flag or whatever...

There is some study that I read once that indicated that as English speaking humans, we think more in the positive sense, So I always try to use Positive terms...

Good article however this point appears to not be true

• Normally if you execute a standalone (“atomic”) INSERT, UPDATE, DELETE or MERGE statement you don’t really need to put it...

Take a look at Azure DocumentDb, it has transactions, indexes, SP's/UDF's, SQL interface and isolation level control for transactions

No FKs and ultimately I think this is deliberate. Once you have...

I like a simple and robust process for live deploys of:

-> lockdown interfaces (architecture may allow queuing/broker to reduce impact here)

-> backup (full/transaction/diff depending on how complex you want your...