When page split happens - which part of the row is moved? Is the whole row copied to a new location [or] that part of the row which cannot be accommodated is copied over?.
"Page spilts will be reduced by specifying fill factor"
This is something I read and got confused thinking about the inserts and updates. There is a certain % of space that will be reserved on setting the fill factor (Okay accepted !!). But, Is the space reservation applied only when entering the data for the first time in the page?
Will the reservation space be consumed while updating and inserting new records? Is this how fill factor help in update and insert.