How appropriate of my predecessor to implement a hammer when a scalpel is needed.

What tools can I use to evaluate what indexes to rebuild?

Thanks for the replies!

Yes the logs are explicitly set to 40 GB today. They were set to 20 GB in the past.

No replication or mirroring.

I'm looking at the job...