troubleshooting Question

Programatically remove all indexs from SQL

Avatar of the_b1ackfox
the_b1ackfoxFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
3 Comments2 Solutions311 ViewsLast Modified:
Hello experts!

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 ;)

Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros