Its quite common that when there is some upgrade, change or release in application, there are chances that our database objects get modified. It may…
Problem A few months back, I had shared a script to automate index rebuild/reorg in a database with fragmentation analysis inplace at https://www.sherbaz.com/2013/06/resumable-auto-index-rebuild-and-reorganize-script/. But that…
As part of SQL server database maintenance, the indexes have to be defragmented on regular basis by rebuild or reorganize for consistant performance. Most of…
Below query will be helpful in finding all missing indexes in a database. I got this query from one of my friend. I am not…
Use below code and make necessary modifications to make it work as per your needs. I am extremely sorry that I couldn’t test below code.…