February 24, 2008 at 8:47 am
When rebuilding indexes with a fillfactor say 80%, where or how do you know next time you want to rebuild the index? I can't seem to find where SQL keeps the fillfactor setting of an index. After I use "alter index" cmd, I can see the fillfactor effect when using showcontig. But when I look at the rebuilt index, I don't see the last fillfactor I used.
In the index props you can set the fillfactor, agreed, but after rebuilding and checking idx props again, you don't see what you have used last. Or are we supposed to document this ourselves?
Best rgds,
T.
February 24, 2008 at 10:26 am
If you don't specify fillfactor, sqlserver just rebuilds using the formar fillfacor.
To view the fill factor value of indexes, use the sys.indexes catalog view.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply