All Questions
Tagged with maintenance-plan database-indexes
2 questions
0
votes
1
answer
108
views
SQL rebuild Index Maintenance Plan is missing the Index Stat Option to set fragmentation percentages?
My maintenance plan is missing the section in the config window that allows you to set the fragmentation > a percentage. Does anyone know how to get this option or is it maybe I'm on too old a ...
0
votes
0
answers
3k
views
Is it necesary to shrink database then rebuild indexes and shrink database again and al this everyday?
I have entered in a new company as a DBA. I have seen they have a maintenance SP that do these steps:
1-Shrink database (this is bad!!)
2- check the indexes and rebuild those that have high ...
- 61