FILL FACTOR

Question

Post reply

FILL FACTOR

TRACEY-320982

SSChampion

Points: 13653
More actions
January 4, 2008 at 4:50 pm

#182406

I have sql 2000 which has tables with fill factors put on these.
When i do backup and restore the SQL 2005 the table is missing the fill factor and been set to zero.
Do i have to manually go back to the tables that i put fill factor on and add these.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Dustin W. Jones Ten Centuries Points: 1207 More actions · Answer 1

are all of the fill factors the same? If so just set the default to that value.

Dustin W. Jones - Database Tech.

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 2

that does seem a bit strange - after restoring your 2000 database are you then setting compat to 9.0.

Do you have an index maint plan which changes these or is this just after restore.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

Strange indeed.

Can find any traces of fillfactor if you script the db at sql2005 side ?

Which fillfactor did you specify ?

If it was the default value (80), maybe that's the reason why sql2005 just presents it in a diffenrent way.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

TRACEY-320982 SSChampion Points: 13653 More actions · Answer 4

I found it, i had to drop all the indexes before i did a major conversion of the database, then recreated the indexes but did not put back the fill factor.

Thanks

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 5

Thanks for the feedback.

I'm glad you've found the reason.