Newbie Question...

Brian DonahueBrian Donahue Posts: 6,590 New member
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:[email protected]<br>
This discussion has been closed.