Reindex

Are you rebuilding all indexes in your database every time? If so, I’d recommend looking into only rebuilding the indexes that actually need it which could save a lot of time (and if you have your SQL data files on SSDs, some wear and tear on your drives as well). I recommend Ola Hallengren’s maintenance script which looks at individual index fragmentation levels and only rebuilds if it exceeds a threshold. It’s really a handy script and it’s one of the first scripts I put into my maintenance SQL database whenever I install a new SQL server instance. It can be downloaded here: https://ola.hallengren.com/

3 Likes