update stats weekly but I am going to dig in to this a bit deeper to see it it can be done better.

Yes have had a look at unused and duplicate indexes. Provided a report to the developers quite some time ago with those along with the most expensive queries etc. They fixed up some of the expensive queries but the unused indexes apparently are mostly vendor ones and could not be touched due to not voiding support.

I think this is something I will just have to keep looking at to find areas that can be improved within the limitations. The customer isnt complaining, just the san guy querying the response times as it makes his monthly reporting look bad.