Viewing 5 posts - 1 through 5 (of 5 total)
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
April 4, 2018 at 9:33 am
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...
April 4, 2018 at 8:28 am
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...
April 4, 2018 at 8:18 am
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...
April 4, 2018 at 7:59 am
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...
April 4, 2018 at 7:07 am
Viewing 5 posts - 1 through 5 (of 5 total)