• Nice article SqlFrenzy!!

    I had an in-database index sproc but I like the additional functionality of needed and unused indexes.

    I am updating the code to run from a Maintenance type database and to run for a specific database. The independent database allows me to update indexes for third party apps and Share Point databases. I am a bit leery of the automatic drop and create of indexes but that looks like a scheduled job on the weekends.

    THANKS!

    Daryl