Hardy21 (10/27/2010)

---

henrik staun poulsen (10/27/2010)

---

'31-Jan-2010'

It that the correct (international) way to hard-code dates?

I think I would have used '2010-01-31' or is it '20100131' to ensure that it will work around...

henrik staun poulsen (10/27/2010)

---

'31-Jan-2010'

It that the correct (international) way to hard-code dates?

I think I would have used '2010-01-31' or is it '20100131' to ensure that it will work around the...

ebay-1087924 (10/26/2010)

---

ta.bu.shi.da.yu (10/26/2010)

---

Sigh. I'm well aware of what a relation is thanks.

I suspect it may be you who is not really understanding that a relational database is so called...

Thanks for the question. I missed a point, but learned something new.

The reason I missed a point is because, when doing some research, I found this text:

"If you attach a...

Robert Mahon-475361 (10/26/2010)

---

EXCELLENT examples actually. Would you prefer the terrorist can't book until he comes up with a SSN that hasn't been used before, or let him book, but...

Ryan C. Price (10/25/2010)

---

Hugo, I mostly like your arguments, but there are a few holes in this one.

The business expects the SSN (for US citizens; for non-citizens, their countries' equilvant...

Robert Mahon-475361 (10/25/2010)

---

ebay-1087924 (10/25/2010)

---

Consider a people list originally keyed by SSN. Replacing SSN with a surrogate key means that -- unless you add a secondary uniqueness constraint -- you...

JJ B (10/25/2010)

---

Hugo wrote:

And consider what so many people call a junction table - a table that represents the many-to-many relationship between two tables. I will usually model these as...

Robert Frasca (10/25/2010)

---

I'm a little hazy on what you defined as the primary key. If it's a many-to-many relationship how can the combination of the two foreign keys represent...

Michael Wang (10/25/2010)

---

this article serves a perfect example of data bases designed by those DBAs who understand little of the real business worlds and tend to take a static view...

When I saw the subject of today's featured article in the daily newsletter, I was enthusiastic. But after reading the article, I am quite disappointed.

I was enthusiastic because there are...

I got it wrong. I blame my total lack of interest in the R2 release.

But a quick question - if Multi-Server Administration was a new feature in SQL Server 2008...

Nice question, and a (to me) surprising large number opf incorrect answers. Shame about the typo in the table name, though - it was obvious that this was not intended,...

David Ziffer (10/20/2010)

---

Hugo Kornelis (10/20/2010)

---

On SQL Server 2008 and later, you could use DATETIME2(7), to get a precision of 100ns. That would reduce the chance of collisions, but not completely...

Hi David,

Thanks for the article (and the series).

I have one (minor) issue with this part. The audit table uses the primary key of the current-row table, plus a datatime column....