Primary Key / Index Question

• Brandie Tarvin

  SSC Guru

  Points: 172994

  More actions

  June 16, 2015 at 6:26 am

  #1805716

  TomThomson (6/5/2015)

  ---

  Braindead comment removed. Must remember to switch brain on before applying fingers to keyboard.

  Don't worry. We all do that (forget to switch brain on) sometimes. @=)

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

• Jeff Moden

  SSC Guru

  Points: 1003861

  More actions

  June 16, 2015 at 7:35 am

  #1805735

  Jeff Moden (6/3/2015)

  ---

  David Burrows (6/3/2015)

  ---

  Jeff Moden (6/3/2015)

  ---

  If the PeriodNo is ever increasing, then yeah, I agree.

  Thanks Jeff

  Yes PeriodNo will always be increasing

  I will go with Tom's suggestion 🙂

  Just one more addition... if the two columns that Tom suggested do NOT make for a UNIQUE clustered index, consider adding the UploadID column as a 3rd column to the clustered index to make it unique and then define it that way. SQL Server has a mighty big love for unique clustered indexes.

  Heh... speaking of engaging the brain, I went back through this thread and found that you, yourself, had suggested the very thing. :pinch:

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