I have new SQL server systems. I am looking for all kind of maintenance procedures one can add to make it work better or prevent any issues.
- Truncating log files every night
- Rotaing SQL server logs each night
Could someone with hands on Sql experience list them here?