Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to rebuild all indexes in SQL DB

Posted on 2010-08-26
2
640 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
ID: 33536450
0
 
LVL 77

Assisted Solution

by:arnold
arnold earned 250 total points
ID: 33536653
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Addition to SQL for dynamic fields 6 47
Linked Server Issue with SQL2012 3 28
TSQL recursive CTE challenge... 8 29
how to restore or keep sql2000  backups useful... 2 12
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…

861 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