The biggest problem is that I have no specific query. I have several applications that use a database. When I try to find queries using a profiler, I get hundreds of thousands of different queries in a matter of minutes.
I focused on the statistics of the indexes using. For example,
LastName (NC index) has more than 8 million seeks, any scan, and a few updates.
FirstName (NC index) has only 7 scans and anything else.
SSMS actually offered a lot of indexes, but I want to create the index (I wrote about above) because it uses more than 10 million seeks.
When I see a few of seeks less than 1000 I don't want to create other indexes.
And I was wondering If I can remove the index on the LastName when I will create this index (composite). Now I understand that this should not be done because order matters