How data will be organized in index page when table has clustered index

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  November 8, 2011 at 1:47 am

  #245703

  Hi all,

  I wanna know how exactly clustered index will work internally when i do CRUD operation on table.

  How data will be organizaed in index page .?

  how page's will get split ?

  Indetail about index.

  Please any body knows or suggest any links regarding that . Am very much interested get down indetail on indexes.

  Thanks,

  Ravi

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  November 8, 2011 at 2:04 am

  #1404302

  This might be a good start: http://msdn.microsoft.com/en-us/library/ms177443.aspx

  http://msdn.microsoft.com/en-us/library/ms189051.aspx

  Regards,

  Iulian

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 8, 2011 at 2:15 am

  #1404308

  This post on Paul Randal's blog should help:

  http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Using-DBCC-PAGE-and-DBCC-IND-to-find-out-if-page-splits-ever-roll-back.aspx

  -- Gianluca Sartori

• ravi@sql

  SSCrazy

  Points: 2121

  More actions

  November 9, 2011 at 9:10 pm

  #1405494

  Thank you very much for both of you .

  Thanks,

  Ravi