• I have i doubt

    when I recreated an index using this script ,I found 1 difference in FILLFACTOR value in case of '0'

    ----------------------------------------------

    This is what I generated before this script

    ----------------------------------------------

    CREATE NONCLUSTERED INDEX [ABC_StudentIdCardNumber] ON [dbo].[StudentAccounts]

    ( [StudentIdcardNumber] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF

    , ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    GO

    ----------------------------------------------

    Then i drop the indexes and create it again using the script generated with above script & again generate Create Script

    ----------------------------------------------

    CREATE NONCLUSTERED INDEX [ABC_StudentIdCardNumber1] ON [dbo].[StudentAccounts]

    ( [StudentIdcardNumber] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF

    , ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, = 100) ON [PRIMARY]

    GO

    ----------------------------------------------

    Are these 2 create index scripts technically same of OR script needs some correction ?