The criteria for choosing a candidate key are:

- uniqueness

- simplicity

- irreducibility

- stability

- familiarity

What...

The value in this article (perhaps not the original intention) is to point out how important it is to be as specific as possible with the requirements. This is NOT...

Would any vendor be allowed to contribute? Are there any vendors, for instance, that are not allowed to advertise on this site due to competing with RedGate? Would they also...

Steve Jones - Editor (11/2/2007)

---

Will,

...

The middle name thing is interesting, though I'm not sure how well that would work. Data quality seems to be suspect and I've gotten quite a...

Sure...

1) Educate yourself on data fundamentals. Everything else follows from the...

For a good reference on database design that's focused on the modeling aspects, I recommend "Data Modeling essentials" by Graham Witt and Greame Simsion (ISBN-13: 9780126445510)

I attended a 3-day workshop...

Although an admirable effort, the author misses the mark.

I would urge readers to, instead, push the folks at Microsoft to implement proper support for relational domains. This is the superior...

Interesting timing on this editorial, Steve.

I'm currently researching StreamBase and some others for potential use in some projects at my company. I saw some of the marketing flurry a...

Never let the facts get in the way of a pithy quip...

http://www.snopes.com/quotes/internet.asp

TroyK

Here's another way for those that like the "tricky" solutions... create a view using a construct that doesn't allow updates and expose only that to your users:

 

CREATE TABLE...

Oops You're absolutely right -- I missed the part about using SQL Server, but now you're adding more conditions...

E, N, T

Translation: This puzzle stumped me...

It certainly makes a difference depending on whether one assumes the "first office" means rightmost or leftmost.

I also worked this out using SQL Server (it's supposed to be a logical...

Ha, ha!

So you registered to make one post spamming us with scientology? How ironic in a thread about ethics...

TroyK