Alter gear SQL index management

Update 06 April 2010: A new version has been released which saves the connection strings

After 3 hours, and a few other gruelling hours of trying to the get UI working Alter gear Sql index manager is now Alive.

Here is how to run it:

Step 1: Start the application:

Step 2 (optional) : select the Filter (Average fragmentation %)

Step 3 : Select database to tune

Step 4: Choose indexes to Reorganise / Defrag

Click “Defragment selected”

Defrag calls Reorganise, and Rebuild the Rebuild method on the index.

Happy re-indexing

Database index defragmenter

I recently came across a best practise which said – do not defragment all indexes in an SQL database. A few reasons apart fro the obvious of it being a costly transaction. Are there any tools that will let me analyse the indexes and i can choose which ones to defragment? I have started creating an application to do this which will soon be hosted on Codeplex, and yet again under the “Alter gear” project name.

Testing of Windows live writer

Windows live writer – this blog goes from that piece of software. This can be syndicated to my windows live space too :)