• Another vote for Ola Hallengren's amazing scripts for index maintenance among other things.

    I generally run it with best-practice settings + force statistics as often as I can, daily if possible or weekly. It's overkill, but heads off a lot of bone-headed questions from analysts like "I read that product X needs maintenance Y are you doing it" "yes, we do that daily".