Fill Factor & Indexing in Sql Server

The data of index column of Sql Table is stored on the data pages in database when we use clustered indexing in sql server this is save on the Data Page when any new data is to be inserted on the table so the indexed column also get a changed so to enter the new data a new storage space is require and this space requirement and fulfill by the Sql Server-2000 one good thing is that these also applicable on the non cluster index also. When data is added or changed, SQL Server may have to reorganize the storage of the data in the non clustered index pages. When we have to add new row to already full index page Sql Server automatically moves the half of row on the page to new page the move of row to next page is called Page Splitting this techniques improve performance and also fragment the store of data on the table. And when we create a indexing on the table we have to fill the Fill Factor to left the extra gaps and percentage of free space on each of leaf level page and also applicable to all the page in that database and reduce the data page leaf according to that page. The values contains by the fill factor is 0 % to 100 % this percentage specify how much data is fill on the page after creating the index on the page. When we take 100 % its means the page is full and contain least amount of storage space for data storing but the thing is that we take percentage to 100% when we have no change on the datapage and data remain as it is and in another we can also say when data table is read only and when we take % to less its means maximum space for datapage and new data should hae enough space to adjustFor more information on Sql Interview Questions Answers visit dotnetquestion.info