Rebuild indexes dynamically for all databases
In this article we are going to learn how we can rebuild indexes for all the databases having fragmentation level more than defined level. Fragmentation level to rebuild the indexes may vary databases to database and In our example we are assuming it as 20%. Which can be suitable for most database servers.
We will also log the details of the indexes before rebuilding them and after rebuilding them in a table to get any report in near future.
And we will exclude all those indexes which have page counts less than 8, i.e. the table is too small and can fit in various different locations intentionally by DB engine.
Log Table Script:
Procedure To build indexes dynamically for all databases:
In this article we can also exclude those database in which we are not interested to perform index rebuild. Just have a … More