MSSQL - Defrag Tool

17. March 2011 12:01

 

I have updated the little tool i use for rebuilding / reorganizing index's in ms sql. The following has changed.

 

  • Added Re organize selected
  • Added filter to remove index's below a certain page count

 

The latest version is avilable here

E-mail Kick it! DZone it! del.icio.us Permalink


MS SQL Index Tool

24. February 2011 21:05

So many people have written ms sql index rebuild script that there are already so many to find on the internet. However not many people have written a small simple application that simply solves the problem for most people. Allowing them to connect, view the status of the index's and rebuild them if required.

Main Features so far

  • Provide list of index's with fragmentation percentage
  • Take recommended action on fragmented index's
  • Rebuild selected index's
  • Rebuild all index's in a database

 

You can read more about it here

 

 

 

E-mail Kick it! DZone it! del.icio.us Permalink