Solved

MS SQL Server 2005 Reindex Software

Posted on 2007-12-04
4
2,088 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Backup & Restore 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.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

821 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