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
.NET is Compile Time OR RunTime Environment?   .Net's framework has CLS,CTS and CLR.CTS checks declaration of types at the time when u write code and CLS defines some rules and

What is BCP utility in SQL SERVER? The Bulk Copy Program (BCP) is a command line utility by which you can import & export large amounts of data in and out of the SQL SERVER dat

Project Description: We require some routines written in C# (.NET) to: * Parse several RESTful APIs to change and push data to RabbitMQ * Pop objects from RabbitMQ and inp

How do you implement prototype pattern in .NET? The Cloning is achieved by using the ICloneable of the System namespace. It has a "Clone" method that actually returns the refer

What is the difference between "DataSet" and "DataReader"? The major differences between "DataSet" and "DataReader" are as follows:- 1)The "DataSet" is a disconnected archit

VB.net Rewrite and Redirect Rules using CodeBehind Project Description: Need VB.net programmer to make some (hopefully) minor code edits to resolve some site issues. I will p

I need Ninjatrader Strategy Project Description: UI for managing orders, entering trades. This project will probably take several months and I need dedicated resources. Sk

What are LINQ query expressions? A LINQ query, also known as a query expression, having of a combination of query clauses that identify the data sources for the query. It conta

List the new features added in .NET Framework 4.0. The following are the latest features of .NET Framework 4.0:     Improved Application Compatibility and Deployment Support

Develop .Net project Project Description: We want to make .net you have to be good knowledge on the subsequent Microsoft Active Directory, Lync 2010 - 2013 databases