Michael Valentine Jones (7/10/2009)

---

John Rowan (7/10/2009)

---

Ha! I'll have to second that one. Not just in forums,...

"Denormalize for performance" and its sibling "You only need to normalize to 3NF".

😉

Actually, varchar(1) is the "best" choice from the standpoint that when people blindly follow advice like this without doing their research, the resulting system will be rife with opportunities for...

steve dassin (4/6/2009)

---

Jeff Moden (4/6/2009)

---

steve dassin (4/6/2009)

---

Sergiy (4/6/2009)

---

steve dassin (4/5/2009)

---

getting sql folks to get their head out of what is essentially a 'constant' (an sql table) and into something that...

Hi Steve;

Earlier in this discussion thread, someone posted a link to software that does comparisons.

It is standard practice for online learning courses (for advanced degrees, continuing education, etc.) to also...

Hi Chad;

I ran into a couple of things with the matrix encoding:

1) The potential sizes of the trees was limited by the encoding of the matrix cells as integers. Even...

Hi Chad;

A while back, I gave a presentation comparing three different methods for representing hierarchies using SQL Server; regular adjacency list, matrix path encoding, and HierarchyID. Since I included the...

Foreign keys, as you have found out, need to reference a candidate key in the referenced table.

If your design is such that the subset of attributes you wish to...

Regardless of the practicality of the particular example used in this article, it is a good introduction to many of the considerations involved in changing a db design and maintaining...

Yep - I just used this as well to track down a stored proc optimization issue (which, BTW, appeared to be caused by a bug in SS2K5). Very nice feature.

TroyK

SAM (9/25/2008)

---

Dennis Miller (12/24/2007)

---

I understand the work around, but it seems to me to be exactly that. I can't help but think the logical design is flawed in some...

Adam Machanic (9/22/2008)

---

cs_troyk (9/22/2008)

---

In addition to the automatic parameterization issues mentioned earlier, I have seen cases where the SQL emitted by a LINQ expression contains a cartesian product (CROSS JOIN)...

In addition to the automatic parameterization issues mentioned earlier, I have seen cases where the SQL emitted by a LINQ expression contains a cartesian product (CROSS JOIN) where it's not...

Julie Zeien (8/12/2008)

---

I agree that it is a good article. However, if you *have* to use EXEC for whatever reason, you can prevent SQL Injection by just replacing all...

Interesting post, but I would disagree with your assessment that this is a phenomenon that has cropped up only recently ("...last 10 years..."). I have been in the game for...