var fDesc=new Array(); fDesc[0] = "SQL Index Manager lets you quickly and easily find out the status of your indexes and discover which databases need maintenance.

You can do maintenance through the UI, or generate a T-SQL script to run in SQL Server Management Studio.

Features:

- Detect index fragmentation: get a full report on indexes across your databases, including severity of fragmentation and the reasons for it.
- Fix fragmentation: choose which indexes to fix based on fragmentation severity – SQL Index Manager will perform the operation for you.
- Reorganize or rebuild: set which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with SQL Server Enterprise Edition.
- Analyze over time: export the results of your analysis to track and report on fragmentation.
- Generate scripts: automatically generate T-SQL scripts to fix fragmentation."; function tShowHide(id, show) { var s = document.getElementById("desc"); if ((s.innerHTML.length<=212 || show==1) && show!=2) { s.innerHTML = fDesc[id]; if (document.getElementById('m1')) document.getElementById('m1').style.display='none'; if (document.getElementById('m2')) document.getElementById('m2').style.display='none'; if (document.getElementById('more_txt')) document.getElementById('more_txt').style.display='inline'; } else { s.innerHTML = ''; } }