Solved

MS SQL Server 2005 Reindex Software

Posted on 2007-12-04
4
2,089 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
[X]
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
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
passing parameter in sql procedure 9 70
Can Unique column have more than one Null? 8 66
Find unused columns in a table 12 97
Trying to understand why my Index is so large 12 52
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

752 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