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
How is a property designated as read-only?  In VB.NET: Public Read-Only Property Property Name  As Return Type Get ?Your Property execution goes in here End Get End Property.

Jquery and MVC 4.5 Training Session I am looking who have industry experience working on Microsoft Technology ( MVC 4.5 ) and Jquery, who will take live online session and provi

What is DAR (Decision Analysis and Resolution)? The Decision Analysis and Resolution is to analyze possible decisions using a formal evaluation process that identifies alternat

I have to develop a Google Map Fix .NET Site on Android(maybe Cross Browser issue) Project Description: A developer has implemented a characteristic which involves data from

Experienced Outlook addin (Microsoft Office) developer Project Description: About us in a nutshell: We are a young start-up that buys a refreshing product in the field of ent

PhotoHandler add-on to display file names Project Description: I want a website with a photo gallery using PhotoHandler. I need the code added/ modified to display the image

What are the difference b/w System.String and System.StringBuilder classes? The System.StringBuilder can have mutable string where a variety of operations can be performed whil

Computer programming Project Description: Solving some issues about traffic jam Skills required: C# Programming, Java, C++ Programming, PHP, Software Architecture

Project Description: We require.NET ( C#.Net or VB.Net ) application to send whatsapp message : - The application could be connected to SQL server database to fetch the conta

What is project management? Applying the knowledge, skills, techniques, tools in project and deliver project deliverable is a short definition of the project management. It's b