url:: https://www.youtube.com/watch?v=UesS08AUcD' BrentOzarl.com/sp_blitz for any disabled indexes in any databases DDL triggers for when people create a table without a clustered index <https://www.youtube.com/embed/UesS08AUcDQ?start=639&end=1057> SQL Server, dont install SSIS, SSRS, SSAS onto the sql server box, the RAM is the most valuable thing you have there Dont run SSMS on the SQL server dont even remote in dump as much memory as you can into it