Frank,
quote:
Now when the fill factor is less than 100% you might be wasting space, when it is 100% you're in risk of getting fragmented indexes which would affect performance.
You will only get fragmentation if the indexed column is updated, or (I suppose) if you get page splitting/a record moving in the data pages.
With static key column data and fixed-width data in teh rest of the table, you can't get any page splitting in the index. So fragmentation wouldn't be a problem. You would need to reindex when new rows are added and deleted or the key column amended though, of course....
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant