Stefan Krzywicki (6/9/2010)

---

Consider the difference between

SELECT E.EmployeeID, E.LastName, E.FirstName, D.DepartmentID, D.Department,

P.Project, P.ProjectID, PD.ProjectDetailID, PD.ProjectDetail PD.Comments

FROM Employee E

INNER JOIN Department D

ON E.DepartmentID = D.DepartmentID

INER JOIN ProjectInterim PRI

ON PRI.EmployeeID = E.EmployeeID

INNER JOIN...

On the contrary, using "TableNameId" for the PK column is harder for the developer not easier...

While it may be "more logical", it isn't really within your power to ensure the developers code things your way. One of the main reasons for aliases is to keep...

I agree with most of the article except for this statement:

"The instant you start writing queries that join tables together ID, name and description are taken outside of their context...

Aaron Cabrele (10/31/2009)

---

It says no additional identity column so that doesn't outrule the hidden one that already exists... As for adding a guid it depends on how strictly you say...

The original article states that you cannot use an identity column but says nothing about adding columns in general. Doesn't the entire issue come down to uniquely identifying each row?...

Jason Whitney (10/1/2009)

---

I have run into this before, and the article gives the first half of the solution. The second part is what I can't figure out; how to avoid...

Unfortunately, the article glossed over quite a bit. The Devil in these details is a much bigger beast. For example, including the effective dates as part of the primary key...

These are my 2 cents are the OA:

RE Capitalizing keywords

IMO, this is an outdated suggestion. Back in the day when people used monochrome editors, it made sense. It might even...

I must say that from a maintenance point of view, one of the hardest skills to teach developers is the skill of removing obsolete code. Many developers simply comment old...

If the idea of the article is present set-based solutions to common cursor implementations, I have one that I'd like to see. It is the simple list result. I want...

Actually, it goes directly to my point. Unlike DBA purists,...

It is clear that you gentlemen are missing the point. That developers should strive to refine their craft is obvious. No one disputes that. That set-based solutions are preferred in...

Jeff,

Look at features you need to know to write the while loop vs. the cross Join. In the case of the while loop, you need to know about the while...

Oh, and as it turns out I didn't waste ANY hours coming up with this one. In fact it took me less than a minute. That's because I,...