What do you mean by Fill Factor concept with respect to indexes Database Management System

The Eduladder is a community of students, teachers, and programmers just interested to make you pass any exams. So we solve previous year question papers for you.
In eduladder you can Ask,Answer,Listen,Earn and Download Questions and Question papers.
Watch related videos of your favorite subject.
Connect with students from different parts of the world.
Apply or Post Jobs, Courses ,Internships and Volunteering opportunity. For FREE
See Our team
Wondering how we keep quality?
Got unsolved questions? Ask Questions

Database-Management-System-->View question

Asked On2017-07-06 05:45:18 by:tarun101

Taged users:

Be first to like this question

Be first to dislike this question
Talk about this  Delete  Like  Dislike
View all qusetions

You might like this video:Infinity
Watch more here

Watch more videos from this user Here

Learn how to upload a video and start earning here

-The value that determines the percentage of space on each leaf-level page to be filled with data is known as Fill Factor. 
- In SQL Server, the smallest unit is a page, which is size 8K. 
- This page can store one or more rows based on the size of the row. 
- The default value of Fill Factor is 100, which has the same value as 0. 
- The SQL Server allows to fill the leaf-level pages of an index with the maximum numbers of the rows it can fit by the         default Fill Factor(100 or 0). 
- When the fill factor is 100 there will be no or very little empty space left in the page.
- The "page split" event happens to accommodate new data if the page is completely filled and new data is inserted in        the table which belongs to the completely filled page. 
- SQL server splits the page in two pages by dividing the data in half and when new data arrives it accommodates the       new data, and belongs to the page which is filled up completely.
- It tells us that a completely filled page is now two half-filled pages. 
- As soon as the page split process is over, the new data is inserted at its logical place. 
- The process of page split is expensive in terms of the resources. 
- More amount of storage space is required to accommodate the small amount of data as there is a lock on the page for a brief period.

Answerd on:2017-07-07 Answerd By:Aparna-Dasgupta

Be first to like this answer

Be first to dislike this answer
Talk about this  Delete  Like  Dislike

You might like this video:Uses of Javascript
Watch more here

Watch more videos from this user Here

Learn how to upload a video and start earning here

Lets together make the web is a better place

We made eduladder by keeping the ideology of building a supermarket of all the educational material available under one roof. We are doing it with the help of individual contributors like you, interns and employees. So the resources you are looking for can be easily available and accessible also with the freedom of remix reuse and reshare our content under the terms of creative commons license with attribution required close.

You can also contribute to our vision of "Helping student to pass any exams" with these.
Answer a question: You can answer the questions not yet answered in eduladder.How to answer a question
Career: Work or do your internship with us.Work with us
Create a video: You can teach anything and everything each video should be less than five minutes should cover the idea less than five min.How to upload a video on eduladder