AndyD

Default fill factors at 0% is fine if you have high spec’d servers and small databases that are not heavily used. In these cases also 90% won’t make a great deal of difference either. What you want to default it to is your call based on the use of the database – heavy reads say leave at 0% (100%) / heavy writes say adjust to 90% - but what do I know!!!!. The default will only be used on new table creation anyway.

Fill factors are not a precise science, I would start monitoring use and adjust the fill factors of the most heavily used and fragmenting tables.

Paul

More for my list thanks. Collations can always be an issue in the UK, they’ve been the bane of my life on several occasions in the past.

Kate

Nice to here from you, I’ve sent you a private message.