John Mitchell-245523 (9/3/2013)

---

The stuff about the execution plans was interesting, too. One thing I don't understand - if the second query has less work to do because of the...

pierre-702284 (9/3/2013)

---

Hugo, that's why I suggested having one column per parameter in my previous post - so that they can be strongly typed rather than stored as strings as in...

The basic idea is nice, but I have my doubts concerning the implementation.

First of all - why is there no primary key defined on the table? And why are all...

Interesting question, but incorrect and misleading answer. I did score a point, but only because I eliminated the other incorrect options first and didn't see the error in the option...

paul.knibbs (8/30/2013)

---

Wow, did not expect that at all--why on earth would Microsoft make a system-level configuration procedure allow any old random garbage to work so long as it happens to...

No,...

I think I managed to include almost all the words of each of the three definitions.

And that was no coincidence! :hehe:

PHYData DBA (8/27/2013)

---

Hugo Kornelis (8/27/2013)

---

Orthogonal.... That is one heap of a...

PHYData DBA (8/27/2013)

---

Nice easy question... I always wondered why you can have a Primary Key on a heap and its still a heap if there is no clustered index on...

sqlnaive (8/27/2013)

---

On the other note, nice to know about the real definition by SQLRNNR and Hugo for Heap table. So the correct definition goes like this:

"A heap table can or...

SQLRNNR (8/26/2013)

---

Though it is easy enough to figure the intent of this question, I disagree with it.

A Heap can have nonclustered indexes. A heap just means that the table...

Good, simple, basic terminology question.

Answer is correct.

Question text is a bit strange. Yes, we call a table with no clustered or nonclustered indexes a heap. But that name also applies...

Hi Tom,

I just wasted two hours typing a long reply to your message, then forgetting to do a copy/paste before posting. I really hate this site at times like that....

First: I am very glad to see a question about normalization. There should be more of those. Much more. So thank you, Tom!

And yet, my pedantic me just has to...

L' Eomot Inversé (8/23/2013)

---

Hugo Kornelis (8/23/2013)

---

Now you're doing the same as you did in the start - simplyfying "it isn't known to the database" to "it isn't known". You are...