Solved

How to rebuild all indexes in SQL DB

Posted on 2010-08-26
2
637 Views
Last Modified: 2012-06-21
Experts,

Is there a way to rebuild all indexes for a DB using a sql script. I am not able to build a maintenance plan, due to permission restrictions.
0
Comment
Question by:aijreal
2 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 250 total points
Comment Utility
0
 
LVL 76

Assisted Solution

by:arnold
arnold earned 250 total points
Comment Utility
http://blogs.msdn.com/b/joaol/archive/2008/01/28/script-to-rebuild-and-reorganize-database-indexes-sql-server-2005.aspx

Builds and process a rebuild or reorganize of an index based on fragmentation level.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now