Hi all.

I have been working on SQL Environment that are really not well due to legacy system mixed with new systems. Need to ask bit of stupid question. I have run few different SQL Scripts to recommend Creating of indexes including BrentOzar FirstResponderKit. Mostly I use FirstResponderKit scripts. Here is where I am bit stuck or not sure what to do.

Normally I create Index with no more than 5 columns in a index. This time I am getting different recommendations. This is recommending adding between 15 – 30 columns. Avg Estimated Cost is between 100% or 65%.  Screen shot attach.

Has anyone added index with so many columns?

​Hi all.I have been working on SQL Environment that are really not well due to legacy system mixed with new systems. Need to ask bit of stupid question. I have run few different SQL Scripts to recommend Creating of indexes including BrentOzar FirstResponderKit. Mostly I use FirstResponderKit scripts. Here is where I am bit stuck or not sure what to do.Normally I create Index with no more than 5 columns in a index. This time I am getting different recommendations. This is recommending adding between 15 – 30 columns. Avg Estimated Cost is between 100% or 65%.  Screen shot attach.Has anyone added index with so many columns?  Read More

​