Re: INDEXDEFRAG FOR SQL SERVER 7.0

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul S Randal [MS] (prandal_at_online.microsoft.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 10:01:19 -0800

I only implemented DBCC INDEXDEFRAG in SQL Server 2000. In 7.0 you're only
option is to rebuild the index.

Can you post before and after results from DBCC SHOWCONTIG? I'm curious as
to how big the index is you're trying to rebuild and why its not removing
the fragmentation. If you're talking about an index split over multiple
files, the 7.0 showcontig doesn't take multiple files into account when
calculating fragmentation so you may not see it go down when in reality it
has.

Regards. 

-- 
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"cedutang" <cedutang@discussions.microsoft.com> wrote in message
news:547F5A53-5B16-4812-BF18-EF7613080CDA@microsoft.com...
> Hi, I have SQL Server 7.0 and I want to to defrag all the index but DBCC
> INDEXDEFRAG it doesnt work, please anybody Know what command exist for
> SQL Server 7.0 ?
>
> I try DBCC DBREINDEX but the fragmentation still.
>
> Thanks.
> cedutang.

Relevant Pages

  • Re: INDEXDEFRAG FOR SQL SERVER 7.0
    ... I only added DBCC INDEXDEFRAG in SQL Server 2000 so your only opion in ... Can you post before and after output from DBCC SHOWCONTIG as I'm curious as ... the fragmentation calculations in DBCC SHOWCONTIG ... before SQL Server 2000 did not take account of multiple files so it will not ...
    (microsoft.public.sqlserver.server)
  • Re: Rebuild indexes on subscriber?
    ... Just to add to Hilary's anwser, you could use dbcc indexdefrag if concerned ... about table locks required when using dbcc dbreindex for SQL Server 2000. ... SQL Server 2005, as well as the Alter Index versions of these DBCC ...
    (microsoft.public.sqlserver.replication)
  • Re: DB Mnt plan issues
    ... If you want to use DBCC INDEXDEFRAG you ... >Jasper Smith (SQL Server MVP) ... >> Thx for your reply. ...
    (microsoft.public.sqlserver.server)
  • Re: Muss man den SQL-Server wie Access komprimieren?
    ... auch wenns es beim SQL Server ... Zuständig dafür sind DBCC DBREDINDEX respektive DBCC INDEXDEFRAG, ...
    (microsoft.public.de.sqlserver)
  • Re: Consequences of Error 644?
    ... If you get the errr while running DBCC - The error is telling you that a row ... but the index entry for some index is missing... ... It says that the problem is a SQL Server ... will happen repeatedly when the customer does the same work which caused the ...
    (microsoft.public.sqlserver.server)