understanding reindexing

• GSquared

  SSC Guru

  Points: 260824

  More actions

  September 3, 2008 at 1:38 pm

  #866777

  Didn't think to look at pages, just checked the total size. Yeah, a page fragment is the reason. Makes sense. Either way, including the clustered index in the non-clustered index didn't increase the size.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Jeff Moden

  SSC Guru

  Points: 1000539

  More actions

  September 3, 2008 at 6:40 pm

  #866900

  bcronce (8/28/2008)

  ---

  kind of off topic but when you said

  it is just a time stamp, thus all distinct

  are time stamps guaranteed unique or 'just as long as you don't do 2+ successive inserts really fast'?

  Wrong kind of time stamp... he's not talking about the datatype...

  --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)
  Intro to Tally Tables and Functions