It's a nice question, but two things surprise me:

(a) that something this fundamental about ROLLBACK and/or GO is considered advanced/hard/obscure enought to be worth 2 points.

(b) that 55% of the...

The ePub link provided appears to be dead.

Artificer

bkubicek (8/4/2016)

---

What if it was called offensive programming? People would download it just to fine out what it was about. You are going on the offensive to make...

Steve Jones - SSC Editor (8/4/2016)

---

You are...

Eric M Russell (8/4/2016)

---

The more defensive you are about declaring foreign key constraints, check constraints, not null constraints, and right sized data types, then the less need you will have...

Steve Jones - SSC Editor (8/4/2016)

---

tamarian (8/4/2016)

---

I stopped calling it "Defensive Coding" a while ago, and started calling it "Advanced Laziness."

The team suddenly became much more interested in learning...

I think the question should have specified SQL Server 2014 SP2 and noted that it applies in no other release.

There's a connect item asking for the feature...

patrickmcginnis59 10839 (8/2/2016)

---

Iulian -207023 (8/2/2016)

---

TomThomson (8/2/2016)

---

Nice question.

It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are not...

funbi (8/2/2016)

---

I once met a guy at passport control at Heathrow - he'd been kept aside because his fingerprints didn't scan. He told me this happened to him every time...

There is enormous variance in what is allowed for passwords at different sites. I have a lot of passwords (about 200) in my safe - the longest 32 characters...

Nice question.

It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are not enforced, allowing them to be...

Bring back QUATTRO, all is forgiven!

Last year I made it to SQL Saturday in Manchester (the only SQL Saturday I've been to) - about 30 miles. This year I didnt make it (last minute...

joejuska (7/30/2016)

---

No I DO NOT WANT TO HASH ONLY THE FIRST 50 CHARACTERS. I WANT TO HASH THE ENTIRE FILE BUT HAVE THE RESULTANT FIELD NVARCHAR(50) OR CHAR(50) INSTEAD...