Ah, Steve... you make me long for the days when I was telecommuting from Hawaii for an Oregon company. Not only did I not have a commute, but my home...

smunson (7/29/2008)

---

TroyK,

I appreciated the story, and it was definitely a good read, but going from "EAV" to anything even remotely resembling what that story described is a rather vast leap....

Hi Steve;

Here's a link to a more detailed account of the problems one can run into with an EAV design: http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/

In a nutshell, expect:

1) Difficult or impossible to declare constraints

2)...

Hi Steve;

I want to preface my remarks by saying that I think it's admirable to want to help someone out with a question they have, and I appreciate that people...

Hi Jeffrey;

Beware of any design advice you get given the lack of information (i.e., conceptual model, requirements, etc.) given in your first post. I also advise you to steer clear...

vasaharshit (7/16/2008)

---

TroyK ,

Thanks a lot for your kind reply!!!

Ok...

Karthik;

It is impossible to properly assess the correctness of a particular database design absent the myriad requirements, external constraints, and complete business rules applicable to the conceptual entities under consideration....

Let's start with the assumption that this...

Stephanie Giovannini (7/10/2008)

---

...

I really wanted to comment on the content of the article. I would like to have seen use cases for the various types of join conditions. I believe...

Looking past the grammatical errors in the article -- which Steve has already explained, I am of the opinion that the underlying content is valuable for those newer to SQL...

The OP's observation rings true in many of the job markets I keep my eye on.

I also agree with many of the follow-up posters that set-based thinking is a different...

Good article on a good use of the CLR. Nice to include code samples. This line from the article, though, gave me a bit of a chuckle:

"We have quite a...

Wyatt Eurich (6/3/2008)

---

What I am hearing in Steve's editorials and in the posts, is that we are still trying to find a way of dealing with the pain in software...

Like some lawyers that work for a percentage of a settlement, maybe a software development contract could be structured such that the development firm gets a percent of the revenue...

Regarding string splitting in CLR vs. T-SQL, check out Paul Nielsen's blog. One of his lessons learned is exactly this issue: http://sqlblog.com/blogs/paul_nielsen/archive/2007/12/12/10-lessons-from-35k-tps.aspx

Would be interesting to see how the...