Post reply

Unused Indexes in your databases

  • May 17, 2016 at 6:40 am

    #1879482

    Thanks for the script.

  • March 1, 2018 at 6:32 am

    #1981620

    mgigani-696113 - Wednesday, February 23, 2011 9:08 AM

    I have a question.Does this statistics persist after a SQL Server service restart? or server reboot etc.

    Hi Mgigani,

    Of  course, if you restart the sql service you continue to have statistics because it is a persistant infomation.

  • March 6, 2018 at 11:13 am

    #1982114

    harriga.rabie-1008938 - Thursday, March 1, 2018 6:32 AM

    mgigani-696113 - Wednesday, February 23, 2011 9:08 AM

    I have a question.Does this statistics persist after a SQL Server service restart? or server reboot etc.

    Hi Mgigani,

    Of  course, if you restart the sql service you continue to have statistics because it is a persistant infomation.

    This is incorrect.  Index statistics will reset if the underlying index is rebuilt "ALTER INDEX ... REBUILD", but not with "ALTER INDEX ... REORG".  All index stats will clear if you restart SQL Server services.

  • March 6, 2018 at 11:32 am

    #1982116

    mgigani-696113 - Wednesday, February 23, 2011 9:08 AM

    I have a question.Does this statistics persist after a SQL Server service restart? or server reboot etc.

    No, the stats reset.

Viewing 4 posts - 16 through 18 (of 18 total)

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