• Biggest piece of advice, don't do this. You really need to look at each index and decide if it needs to be created or not. The missing index DMV can also provide you with multiple indexes that are virtually the same, but with some investigation can be combined or possibly eliminated by a slight modification to an existing index.

    Do not blindly add indexes just because the DMV or DTA say you need them. Really check them out and test each possible change.