Thanks for the help, Jeffrey and Brian. This is the quote I was after:

"

INSERT queries that use SELECT with ORDER BY to populate rows guarantees how identity values are computed...

One benefit to understanding methods for merging without using the T-SQL MERGE command is that you can more easily port concepts to other platforms. For example, Snowflake supports _a_ MERGE...

Hmmm... an even older reference than the 2010-era stuff I found, and on an unmaintained page. Not giving me much confidence that the behavior has been preserved and is still...

Thanks for the additional clarification, Solomon. Very interesting behavior. I don't know, though, that I've constructed many (any) EXISTS predicates that weren't correlated in some way, hence always referencing at...

OK - I'm missing something or misunderstanding the point, because SELECT 1 or SELECT * works fine for a user that is denied permission on a column within the table...

I saw the first article that set off this back-and-forth a couple weeks ago (gave me quite a chuckle). The scientific community has a description for ideas like it: "not...

One other important point (and, to me, the best reason to use QUOTENAME), is the built-in escaping of certain characters, which helps to prevent SQL Injection attacks in certain scenarios.

Sure - Stephen King's next novel has been outsourced to Bangalore. 😛

I always thought a compensation structure modeled after sports teams made sense in the context of high-performing development teams. The manager ("coach") makes a good salary, but it's the star...

Fantastic article, Jason!

I know what a challenge it is to set up a realistic test scenario that illustrates the behavior you're trying to explain, and you did a great job...

arnipetursson (11/1/2013)

---

Am I the only one bothered by the lack of unique constraint/index on the natural keys in in the new tables.

The new design allows the insertion of duplicate entries...

Nice topic, Steve, and I have to say I'm not at all surprised at the numbers people are reporting.

An interesting related question - for those that are "development dba's" or...

Excellent article, Jeff! I look forward to Thursday's installment.

I've played around with mixing these two representations of hierarchies before, but had never gotten past the performance issues, so it's great...

opc.three (11/8/2012)

---

cs_troyk (11/8/2012)

---

opc.three (11/8/2012)

---

cs_troyk (10/29/2012)

---

Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant....

opc.three (11/8/2012)

---

cs_troyk (10/29/2012)

---

Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant. It's something...