InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is the fill factor in SQL? What is its default value? |
|
Answer» The fill FACTOR is the percentage of space on each leaf-level page that will be filled with data. The smallest unit in SQL SERVER is a page, which is made up of 8K pages. Depending on the size of the row, each page can store one or more rows. The Fill Factor's default value is 100, which is the same as the value 0. The SQL Server will fill the leaf-level pages of an index with the highest NUMBER of rows it can fit if the Fill Factor is set to 100 or 0. When the fill factor is 100, the page will have no or very little vacant space. |
|