MSSQL:Ultimate configuration for rebuilding indexes+statistics
- by Niels Bosma
My database is growing slower even though I have a bunch of indexes setup. Yesterday I figured out that I need to setup a maintenance plan to build the indexes etc.
So my question is what's the ultimate configuration for this?
Do I need All: "Rebuild idex task", "Reorganize index task" and "update statistics task". Anything else I need to setup. Shrink database? (Today, the only maintenance plans I have is backup)
Does it matter in what order I run them?
Any configuration options I should be aware of?
I've read of problems with log growing wild, how do I fix that? My transaction log is quite small and is usually a problem for me.
-