I haven't seen this before. Did you try executing this without a Fill
Factor?

Like this, dbcc dbreindex (table_name)

John

-----Original Message-----
From: Harish, P (Poornima) [mailto:[Email Address Removed]
Sent: Monday, April 28, 2003 1:32 PM
To: LazyDBA.com Discussion
Subject: dbcc dbreindex - no change in scan density...



Hi All

running dbcc dbreindex (table_name,' ',80) did not make any changes to
the
scan density (which was 50 to begin with). Any tips on why and what to
look for?

tia
pH


************************************************************************
*********
The information transmitted via this e-mail is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination
or other use of, or persuing of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you are the recipient of this in error, please contact
the
sender and delete the material from any computer.
************************************************************************
*********


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page