Hi there,

Can anyone please advise/share how you handle your fill factor settings? Currently, I am looking at a database (20 GB) size and there are at least 10 transactional tables in it. The current fill factor is set to default which is 0. In BOL it says, every time the indexes are being rebuilt, it will set the index page to 100% full thus creating page splits everytime a new data is inserted.

I am running DBreindex once a week too. Is this efficient enough?

Daylinda Sanchez


We should be taught not to wait for inspiration to start a thing. Action always generates inspiration. Inspiration seldom generates action.
-- Frank Tibolt


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004


----------

The information contained in this e-mail and any attachments is confidential
and is intended for the attention and use of the named addressee(s) only.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Chelmer Limited.
MS Sql Server LazyDBA home page