I have to remove all exisiting indexes from a DB including ones with contraints. Is there a script that can do this? I am an index noob, and no nuthing more than to be able to find them... Seems that is going to be changing after today...
For those that must ask, a vendor needs to update the DB, and doesn't understand why we tuned the db (60% increase in speed would be the answer ). So I have to remove all the indexes, so they can update the DB and reapply *their* indexes... AND THEN I will sneak back and retune it later, lol DB is running SQL 2005.
Any help is appreciated. I award points based on the knowledge you share ;)