Options
Newbie Question...
Brian Donahue
Posts: 6,590 Bronze 1
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>
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.
