Re: Fill Factor

Tech-Archive recommends: Speed Up your PC by fixing your registry

The case is: I have a table with two fields, ID as Int, Doc as Image datatype,
the second field is used to store images of type "tiff".

i discovered that insert operation takes more than 30 sec when FillFactor
become 90%, but when i return the value to 0% the insert operation takes less
then 1 sec.

the table size around 50,000 rows.

Note: there is no maintaince plan againts this table.

"Andrew J. Kelly" wrote:

My guess would be that someone set up a maintenance plan that reindexes the
tables and has the fill factor set to 90 there. But why would this cause
problems? I would think it would eliminate more problems than it would
cause. Having the fill factor at 0 means that each leaf level is essentially
100% full and any additional insert or update with more bytes than before
will cause a page split. With a Fill Factor of 90 you at least have some
room to operate and still minimize page splits.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Saeed Abd Al-Ati" <SaeedAbdAlAti@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:92FA67B7-FAAC-4F74-9F3D-4F4CEEB81DF4@xxxxxxxxxxxxxxxx
Hi,

I am facing a Weird problem in configuring the Fill Factor for my
production
database, i deployed a database to a client and sit the Fill Factor for
all
indexes to be "0" which is the default value, after 1 week the value
changed
to be "90" which caused some problems in the application, since there are
some problems in HD allocations, my question is: how this value changed
automatically? taking into consideration that there is no specific
devleopment/administration script applied on the Database.

Thanks in advance.


.

Relevant Pages

  • Re: Fill Factor
    ... I have a table with two fields, ID as Int, Doc as Image datatype, ... the second field is used to store images of type "tiff". ... Andrew J. Kelly SQL MVP ... database, i deployed a database to a client and sit the Fill Factor for ...
    (microsoft.public.sqlserver.setup)
  • Re: Using Left Function in table design.
    ... >I am trying to create a simple database, ... >first could be entered as "Jason" and the second field would ... In any form or report where you need to display the first letter, use this formula as the controlsource of a textbox. ... Basic rule of database design - you *normally* do not store in a table that which can be calculated from existing data. ...
    (comp.databases.ms-access)
  • VB 6 OraOLEDB problem with database record retrieval
    ... Two fields are being queried for and placed in a recordset. ... (question marks). ... the database, the second field does have values. ...
    (microsoft.public.win32.programmer.ole)
  • Re: Download image datatype to Jpegs or GIFs
    ... I want download photos (image datatype) from a SQL-2000 database ... into windows based jpeg files. ...
    (comp.databases.ms-sqlserver)
  • Using Left Function in table design.
    ... I am trying to create a simple database, but it's proving too complex ... first could be entered as "Jason" and the second field would ...
    (comp.databases.ms-access)