title: Sequential Guid and fragmentation
body: <p>I'm trying to understand how sequential guid performs better than a regular guid. </p>
  
  <p>Is it because with regular guid, the index use the last byte of the guid to sort? Since it's random it will cause alot of fragmentation and page splits since it will often move data to another page to insert new data?</p>
  
  <p>Sequential guid sine it is sequential it will cause alot less page splits and fragmentation?</p>
  
  <p>Is my understanding correct?</p>
  
  <p>If anyone can shed more lights on the subject, I'll appreciated very much.</p>
  
  <p>Thank you</p>
  
  <p>EDIT:</p>
  
  <p>Sequential guid = NEWSEQUENTIALID(),</p>
  
  <p>Regular guid = NEWID()</p>