Hi Linson,

I don't use the term "natural" key, since it is confusing. What is "natural" about an SSN? It's just a random number assigned to you. (Your DNA code would...

Hi all,

I think this is a great question, though thwarted by an incorrect answer, unfortunately.

The question is great because hardly anyone knows exactly how this works. That is shown by...

Hi Linson,

You are wrong 😉

Values for a surrogate key are system-generated, that is correct. They need not start at 1, need not increment, and need not stop at the number...

Hi Bitbucket,

bitbucket (4/7/2008)

---

Proposed it twice before and will propose it again.

Steve ask for volunteers to be appointed to a panel that checks and double checks these question BEFORE...

Hi Jack,

Yes.

Also have...

Hi all,

In contrast to some other people in this discussion (and in many other QotD related discussions), I really don't care about points. Points are just a fun way to...

Okay, I've got two comments this time.

One - the answer key appears to be wrong again. The article referenced is kind enough to explain that both 1000^8 and 10^24 are...

Hi Steve,

I hope everything went allright with the kid's tooth 🙂

I have to agree with Joshua Perry on the new version...

The explanation offered doesn't make much sense to me.

"tempdb is reallocated every time the instance starts. This reallocation requires the existence of model to be successful."

But who has suggested dropping...

Hi Jeff and all,

I had just composed a lengthy reply, and when I posted it I got an error about an expired session and all my text was lost. Have...

Matt Miller (3/14/2008)

---

Hugo Kornelis (3/14/2008)

---

I'm just trying to get a read on where you place this versus performance, efficiency etc. Would you implement standard code over better performing code?...

Matt Miller (3/14/2008)

---

And there are other folks who don't know that what you call Oracle syntax is actually ANSI-standard syntax, and that the optional FROM clause in SQL Server is...

Jim Russell (3/14/2008)

---

RE CTEs. I love them and use them, but I had gotten the impression that they too were a MS nonstandard extension. Are they part of the SQL...

Jack Corbett (3/14/2008)

---

Sure. It's in BOL, or the online...

Hi all,

I'm sorry for having to be the party pooper, but there is just too much wrong with this article to let it slip.

many people don't know how to do...