questions about sql

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  September 7, 2016 at 4:59 pm

  #1899683

  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!

  Understood. To me, "Table with no clustered index" isn't the name, it's the description. For example, in the following URL, they didn't label the article "Estimating the Size of a Table with No Clustered Index".

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

  Considering that they can both be created by the CREATE TABLE statement, I'll agree with your point.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)