@dennis-jensen I whole-heartedly agree to all you have stated. Thank you!

I found this which seem to be the solution i'm looking for:

finding and eliminating duplicate and overlapping indexes.

https://www.sqlservercentral.com/articles/finding-and-eliminating-duplicate-or-overlapping-indexes-1

@dennis Jensen, thank you!

Thank you, Scott. This stored procedure generates code for all indexes or similar/duplicate indexes?

So we have some indexes that are very similar; some of the tables seem a bit over indexed. The real question here is, how can we merge the indexes that...

Thank you, David!

Thank you Jeff! This is helpful!

Thank you!

I am not sure how to move  from the staging table to the final table (physical table). this is something I should know but I am not sure. I am...

• This reply was modified 1 year ago by  EM2.

.

How can I automate this? Like if I had multiple of such files to import. Will I have to just follow the same process?

Thanks so much. Can this be done in SSIS? Like the splits

Ok, I have attached the sample file. Thanks.

Ok. I have been able to import the all of the file's content into a single column using SSIS; parsing the file before loading into its final table is where...

Thank you for your response; because the file I have in highly confidential I cannot share it here. However, it has some similarities to the structure of this file. The...