Well it just seems to filling up, and I have to continually add more space
to my devices. The amount it grows doesn't seem porportionate to the amount
of data entered into the database daily it seems to grow *waay* too fast. We
upgraded to larger hard drives a few months ago due to the space issues, and
now we're almost in the same situation. I was unable to find anything that
would point me in the direction of the correct solution, but the FILLFACTOR
item seemed to stand out, however the MS docs suggest that a lower
FILLFACTOR setting will result in the database consuming more, not less disk
space, so I'm a little confused.
> Chris,
> Perhaps you could begin by clarifying the statement "I have an SQL 6.5
> database that seems to be filling way too rapidly". What does that mean?
Do
> you need to keep adding space to your database devices?
> My personal suspicion re: a FILLFACTOR = 83, is that the individual who
> coded this thought he knew something and didn't really. In almost all
cases,
> it makes sense to just use the default FILLFACTOR value. I strongly
suspect
> that the FILLFACTOR value has absolutely nothing to do with what ever
> problem you are having, but since it's not clear exactly what problem you
> are having, I can't absolutely state this with certainty.
> The FILLFACTOR is a parameter more closely associated with performance
than
> with space (although it does influence the amount of space used). If you
> believe that you are not re-using space, check whether you have a
clustered
> index on each and every table. SQL Server 6.5 can reuse space only on
tables
> that have a clustered index.
> ----------------------------------------------------------------
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.
> > Can somebody explain to me how to properly use the FILLFACTOR option on
my
> > indexes? Specifically, I have an SQL 6.5 database that seems to be
filling
> > way too rapidly. I inherited this database from someone else, and
noticed
> > that they have a weekly task setup to rebuild its index. In the command
> for
> > rebuilding this index I noticed that they have the FILLFACTOR = 83
> > parameter. The SQL help seems confusing to me about this, and I'm not
> clear
> > on what this is doing, and / or if it is what I want it to be doing.
> > TIA,
> > Chris
by