Solved

MS SQL Server 2005 Reindex Software

Posted on 2007-12-04
4
2,086 Views
Last Modified: 2012-08-14
Hello,

Instead of using the DBCC command to do an internal defrag or reindex of the database. Does anyone know of any specific or good software that does this and is easy to manage? I am curerntly running Diskeeper to do an external defragmentation, now I am looking for something to allow me to do an internal reindex of the databses.

Thanks
Dr Ego

Open in new window

0
Comment
Question by:Dr_Ego
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
Steven_W earned 125 total points
ID: 20493674
DBCC REINDEX is the only proper (and recommended) way to re-index a table or view within SQL

What do you hope to achieve by running a re-index ... ?

DBCC REINDEXdoes exatly what you say that you are looking for
0
 
LVL 1

Author Comment

by:Dr_Ego
ID: 20495237
I was looking for a way to run the reindex faster or a software that allows for scheduling or other beneficial tools.

Also, to manage 5 or more database servers without doing it manually..
0
 
LVL 13

Assisted Solution

by:Steven_W
Steven_W earned 125 total points
ID: 20496134
The reindex can only be run "faster" using the "Keep-online" option (I think this is only Enterprise edition that allows it"

As for scheduling, there are various ways of doing this
  1- SQL Agent
  2 - Database meintenance plans (which internally use SQL Integration services)
  3 - a "SQLCMD" script.

Whichever method you choose, it is almost certainly going to use the database's own DBCC DBREINDEX command.

--

If you're using SQL 2005 (as opposed to SQL 2000), take a look at the following command ("ALTER INDEX)

This is the successor to  DBCC DBREINDEX and DBCC INDEXDEFRAG.

http://msdn2.microsoft.com/en-us/library/ms188388.aspx
0
 
LVL 1

Author Closing Comment

by:Dr_Ego
ID: 31412611
Thank you the help!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 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

25 Experts available now in Live!

Get 1:1 Help Now