If fill factor is specified as 100 for a table what will be the impact of this?I want to know any updation or insertion will be possible or not?SQL BOL - The FillFactor property exposes the percent of each page used to store index data when the index is created. Note: this only applies at the time the index is created - SQL Server doesn't try to maintain the FillFactor: it is just a starting point.
With FillFactor = 100, you are requesting your index pages to be 100% full when the index is created. You will be able to insert/update, but the likelihood of a page split is related to the fillfactor - the higher the FillFactor, the more likely SQL Server will have to split the page. Thus, if you have heavy changes, SQL Server will have to split index pages more frequently.|||Just to add to it, - only if inserted/updated data fits in the middle of an existing page.|||a fill factor of 100 is essentially a fill factor of 0 or not issuing the fill factor statement at all.
check out books online {Fill Factor}sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment