number of records in a page

• Ranga N

  SSChasing Mays

  Points: 642

  More actions

  October 1, 2003 at 1:42 pm

  #176730

  Hi,

  A page can store 8060 bytes of data(132 is reserved for headers out of 8192). If a record is 3000 bytes, can a page hold only 2 records or it will hold 2 records plus a portion of the 3rd record also??

  Thanks,

  Ranga

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  October 1, 2003 at 2:59 pm

  #476638

  Two records. SQL Server does not span records across pages.

  
  "Keep Your Stick On the Ice" ..Red Green

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  October 1, 2003 at 4:36 pm

  #476656

  Two is correct.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net