Forum Replies Created

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

  • RE: Automatically Create indexes as needed

    Thanks, Jeff.  One other thing to note.  This job is scripted to not have a scheduled run time specifically because of the issues that I previously talked about.
    Thanks!
    Steve

  • RE: Automatically Create indexes as needed

    It's limited to the custom indexes that are created on purpose.  Assuming that other indexes are by nature already specifically created to address specific performance in the first place so...

  • RE: Automatically Create indexes as needed

    Good points.  I had posted the script to help out and your comments are appreciated.  I'll try to keep that in mind so it is a bit more detailed the...

  • RE: Automatically Create indexes as needed

    It actually checks all custom indexes and compares the columns and include columns to ensure that they do not exist in other indexes.  As far as over-indexing goes that is...

  • RE: Automatically Create indexes as needed

    This has been designed to specifically ensure that duplicate indexes never occur if you actually look at the script.  I have run this script for years with very good results that...

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