Nebojsa Ilic;

I second...

George Heinrich (1/2/2008)

---

Ahhh...ok. I think I get it now. The view and the digits table are just there to throw an error in the event that the wrong criteria are...

George Heinrich (1/2/2008)

---

These articles are very good...but the author lost me on article 4.

Could you go into more detail on how the indexed view and using the negative matches...

Dennis Miller (12/24/2007)

---

It's great to see some attention to conceptual/logical modeling from the SQL Server community. In my experience, DB practioners with that persuasion tend to jump right to...

Hi Ken;

This article series is concerned with modeling and implementing the model in such a way as to prevent "bad" data from entering the system (hence the name "Toward Integrity").

As...

kenambrose (12/12/2007)

---

Hi Troy,

Good series! I'd like to suggest that you include a bit more "real life" stucture to the model. Just enough to make the examples more...

Hi Timothy;

I'm glad you brought this topic up as it lets me expand a bit on the design tradeoffs I'm making as well as reiterate my position on the poor...

Matt Miller (12/7/2007)

---

The one that doesn't say anything of the physical implementation is the Mathematical model. ...

Jeff Moden (12/6/2007)

---

I would disagree with your assertion that set based programming is code that touches rows once or very few times and that the query you specified is not...

Matt Miller (12/6/2007)

---

Well - set-based processing entails a bit more than either description. Jeff's taking issue with the fact that the external query has to be evaluated one single...

Jeff Moden (12/6/2007)

---

"Set-based" refers to a logical construct--the programming model. "RBAR" refers to a physical implementation of the solution (at least as you use it in the article). I assert...

Jeff;

A good lead-in article... it will be nice to see the solutions you propose, both for SS2K and SS2K5 (I imagine they'll each look quite differently).

One criticism I have is...

kenambrose (12/3/2007)

---

Glad to see this effort! Too many sql programmers are way behind the curve in understanding conceptual and logical modeling and the theoretical basis that should be guiding...

jomobono (11/21/2007)

---

cs_troyk (11/21/2007)

---

jomobono (11/20/2007)

---

First off regarding requirements, this is a personal opinion, but here goes.

Steve has provided ample requirements based on the scale of his project to prototype a...

jomobono (11/20/2007)

---

First off regarding requirements, this is a personal opinion, but here goes.

Steve has provided ample requirements based on the scale of his project to prototype a preliminary system....