As everyone has said, there are no catch all scripts, but if your company is willing to purchase software, we use Idera's SQL Doctor which I have found very useful, and like anything it doesn't catch everything but is a good starting point and will give you a lot of info, including transact to fix certain issues. Be advised these are generic and that needs to be taken into account when deciding whether to act on the recommendations given.