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
Show the code for the file dependency in cache? Partial Class Default_aspx Public Sub displayAnnouncement() Dim announcement As String If Cache("announcement") Is Noth

Question 1 Discuss the following with respect to .NET Technologies Web Applications Web Server Connections Question 2 Write a sample program using ASP.NET explain

Explain the different services provided by DLR to CLR. The services given by DLR to CLR are used for supporting dynamic languages. These services include the following: Exp

What is the relationship between a class and an object? A class acts as a blue-print that explains the properties, states, and behaviors that are common to a number of objects.

Read an Array and perform Sorting - C# program Can any one assist me in performing sorting of an array.

Project Description: Looking for a developer who will develop a web portal like zulutrade, some features will be taken from signaltrader The changes would be like: 1) Only

Differentiate between managed and unmanaged code? Managed code is the code that is implemented directly by the CLR instead of the operating system. The code compiler first comp

Project Description: We have a reconciliation tool, written in VB.Net that selects customer data (email, addresses, etc) from three different data sources and compares them with

What are the precautions by which SQLSERVER Mode work properly Following are the things to keep in mind so that the SQLSERVER Mode works properly:- A) In the SQLSERVER mode,

How do I force the Dispose method to be called automatically, as clients can forget to call Dispose method? To Call the Dispose method in the Finalize method and in the Dispose