Fill factor, DOT NET Programming

What is fill factor?

The 'fill factor' option describes how full SQL Server will make each index page. When there is no free space to insert a new row on the index page, the SQL Server will create a new index page and transfer few rows from the previous page to the new one. This operation is known as page splits. You can decrease the number of page splits by setting the appropriate fill factor option to reserve free space on every index page. The fill factor ranges its value from 1 through 100 that specifies the percentage of the index page to be left empty. The default value for the fill factor is 0. It is treated similarly to a fill factor value of 100, the difference in that SQL Server leaves some space inside the upper level of the index tree for FILLFACTOR = 0. The fill factor percentage is used only at the time when the index is created. If the table contains only the read-only data (or data that very rarely changed), you can set the 'fill factor' option to 100. When the table's data is changed very often, you can reduce the fill factor to 70% or whatever you think is best.

Posted Date: 9/24/2012 4:28:34 AM | Location : United States

Related Discussions:- Fill factor, Assignment Help, Ask Question on Fill factor, Get Answer, Expert's Help, Fill factor Discussions

Write discussion on Fill factor
Your posts are moderated
Related Questions
Shipping Emails Bulk System Project Description: We need to develop a system for sending emails to a large mass, without using third-party services, administration by us, or

Website update... Immediate need I want someone experienced in ASP.NET who can set up PayPal on my website by Feb. 1st. I would similarly like to have some changes made in the t

Custom Login Page for SharePoint 2013 with Active Directory Project Description: I would like to prepare a webpart or an application for Sharepoint 2013 foundation. The we

What is the use of DataView? User-defined view of a table is contained in a DataView. A complete table or a small section of table depending on some criteria can be shown by an

What is assembly? Assemblies are the building blocks of .NET Framework applications; they form the fundamental unit of deployment, version control, reuse, activation scoping, a

Can you give a practical implementation of FAÇADE patterns? The Façade pattern sits on the top of lot of the subsystems & makes access easy to interfaces of these subsystems. T

Ask question #Minimum 100 words accepWrite an ASP.NET program that allows you to create and populate a CheckBoxList control by accessing the Title field from the Movies database ta

What is nested Classes? You can access an array using the INDEX value of that array, but how many times you know the real value of the index. The Hashtable provides a way of ac

How to use ActiveX Control in .Net ? ActiveX control is a special type of COM component  that supports a User Interface. Using ActiveX Control in your .Net Project is even