What are the challenges you face when working across database platforms? Take the survey
Options

Newbie Question...

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 28, 2002 10:05AM in SQL Compare Previous Versions
Hi Gary,
Thanks for your enquiry. My name is Brian Donahue, and I am a support engineer at Red Gate Software. Specifying a fill factor on an index can affect database performance. It's the percentage of space allocated for an index that will fill up before the server will split the space for new rows. I think most of us don't feel too bad about simply leaving it alone!
It's easy to make SQL compare ignore fill factors.
Go to View->Options
Click the Objects tab
Tick "Ignore Fill Factors"
Please don't hesitate to contact me if you need further assistance.
Brian Donahue
Technical Support Engineer
Red Gate Software Ltd.
T: +44 870 1600 037
E: mailto:brian.donahue@red-gate.com<br>
This discussion has been closed.