Self-numbered primary key creation

• Junior Galvão - MVP

  SSCertifiable

  Points: 7009

  More actions

  November 10, 2020 at 12:00 am

  #3801888

  Comments posted to this topic are about the item Self-numbered primary key creation

• Rune Bivrin

  SSCrazy Eights

  Points: 8616

  More actions

  November 10, 2020 at 10:02 am

  #3806286

  I'm sorry, but I just don't understand what is being asked here.

  ---

  Just because you're right doesn't mean everybody else is wrong.

• NBSteve

  SSCarpal Tunnel

  Points: 4164

  More actions

  November 10, 2020 at 7:30 pm

  #3806512

  The wording is confusing, but I believe the question is trying to ask:

  "Given that SQL Server creates statistics for a primary key upon its creation, what will be the state of the histogram for the statistics of the primary key column above?"

  1 - The histogram is fully created and populated with the distribution of the data in the table

  2 - The statistics will be created, but without any histogram distribution details

• Jeff Moden

  SSC Guru

  Points: 1004619

  More actions

  November 10, 2020 at 8:50 pm

  #3806551

  Just to be sure... the CTE's that generate the sequence in the code are NOT "recursive" CTEs.  They're "cascading" CTE's and there's a huge difference in both performance and resource usage.

  --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)