Post reply

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

  • 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'

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply