[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 648
  • Last Modified:

How to rebuild all indexes in SQL DB

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
aijreal
Asked:
aijreal
2 Solutions
 
dba2dbaCommented:
0
 
arnoldCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now