patrickmcginnis59 10839 (9/7/2016)

---

Jeff Moden (9/7/2016)

---

patrickmcginnis59 10839 (9/7/2016)

---

Jeff Moden (9/2/2016)

---

On 2)

A lot of people will answer yes or no on this without clarifying and it could be a trick question. In my mind and in the documentation, if a "table" doesn't have a clustered index, it's not actually called a "table". It's called something else and I'll let you do the research to figure that out so they can't pin you on a similar question in the future.

"A heap is a table without a clustered index."

https://msdn.microsoft.com/en-us/library/hh213609.aspx

I was looking forward to the OP discovering such a thing for themselves because it looks like they need the practice.

You said the documentation says heaps are not called tables, when a routine search calls up an msdn page mentioning that a heap is very much called a table and in fact, I'm having difficulty finding any documentation that declares that heaps should not be called a table. So if you could post that doc that would be great!