Showing posts with label jobexecute. Show all posts
Showing posts with label jobexecute. Show all posts

Thursday, February 16, 2012

am I reading this right?

When I see this in my Maintenance Plan job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
It could mean a FF of 10, but thats not the way Im reading it.
TIA,
ChrisR
Yes That is a fillfactor of 90%
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> When I see this in my Maintenance Plan job:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
> I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
> It could mean a FF of 10, but thats not the way Im reading it.
> --
> TIA,
> ChrisR

am I reading this right?

When I see this in my Maintenance Plan job:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
I think that means a Fill Factor of 90%, leaving 10% free. Is that correct?
It could mean a FF of 10, but thats not the way Im reading it.
TIA,
ChrisRYes That is a fillfactor of 90%
http://sqlservercode.blogspot.com/
"ChrisR" wrote:

> When I see this in my Maintenance Plan job:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> C8270137-357F-4781-BFB8-CF86BE6A80B5 -WriteHistory -RebldIdx 10 '
> I think that means a Fill Factor of 90%, leaving 10% free. Is that correct
?
> It could mean a FF of 10, but thats not the way Im reading it.
> --
> TIA,
> ChrisR