Since all my client have 3rd party software, I can only drop my indexes not those who came with original software.

Talking about maintenance, I use to reindex also in week...

I'm free lance DBA, one part of my work in any client is to improve performance.

So I use to check execution plan and make some indexes.

After a...