index architecture

• sej2008

  SSCarpal Tunnel

  Points: 4495

  More actions

  January 14, 2013 at 11:30 pm

  #272745

  I want to get the Idea what exactly Index configuration means?

  and what exactly is the the size of index pages of non-clustered index and what is the maening of key/value in Indexes?

  Thanks in advance

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 15, 2013 at 1:19 am

  #1577167

  Index pages are 8kb, like all other pages in SQL.

  http://www.sqlservercentral.com/articles/Indexing/68439/

  http://www.sqlservercentral.com/articles/Indexing/68563/

  http://www.sqlservercentral.com/articles/Indexing/68636/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Grant Fritchey

  SSC Guru

  Points: 398911

  More actions

  January 15, 2013 at 4:27 am

  #1577245

  And for more you can go to the books. SQL Server 2008 Internals by Kalen Delaney is one of my favorites.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  January 15, 2013 at 4:34 am

  #1577251

  http://www.sqlservercentral.com/stairway/72399/

  hehehe

  Jayanth Kurup[/url]