Why Page Number in SQL Server database is not starting from zero

• info.sqldbamail

  SSCommitted

  Points: 1741

  More actions

  April 21, 2017 at 1:48 am

  #329901

  I have a question on SQL Server page, I have created a new database with only one new table as below

  Here is the Code:

  CREATE TABLE PAGETEST
(
ID int primary key
)
GO
INSERT INTO PAGETEST VALUES (200)

  
  When i see my staring page number= FileID:pagenumber it is starting 1:285
  Q 1). Why my page not starting from 1:0 or 1:001?
  Q 2).Will this page number have dependency from model database? Kindly find the below images
  Kindly find images below

  

  

  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  Save a tree... Please don't waste paper unless you really need to!

  When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 21, 2017 at 2:00 am

  #1939249

  While it may be a new database, the system tables were there before you created the user table, hence the first couple hundred pages are already allocated.

  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