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