sql - Will modifying any row data fragment my clustered index? -

Now I understand that a package index contains all the row data, not just the index field, in relation to its fragmentation I am trying to understand the implications of this.

We have a table like this:

  files to create tables (id unique identifier, field 1 Nvarchar (300), field 2 navigator (300) Null, Field 3 Neutral (300) Null, Binary Verbinary (Maximum) blank)  

Now all of these lines are filled with data, and then the clustered index In some lines you suddenly set to clear Field 1, Field 2, Field 3 and Binary We do.

An implication of this, as I think in an incomprehensible way instead of making intervals to clear all of these values, and the index will be broken. I think the rows are still in the right order, however, is it really the index fragmentation?

Or you might think about it on the other side; If they are null to start with everyone and you insert data, do you alter the data on different pages and get fragmentation in the index?

In addition, I know that LOB data is stored in a separate allocation unit, although I'm not sure what its effects are; Does this mean that there should be no effect on clustering index fragmentation to make binary (or population) empty?

An implication of this, as I think in an intuitive way, is that All these values ​​will make the clearing interval, and the index will be split. I think the rows are still in the right order, but is it really the index fragmentation?

Yes. You will not get compacted data pages to retrieve the SQL Server location that you will find internal fragmentation. You can use the tool to see it. Despite it being dependent on the burden of your work, it is not a bad thing. In some parts, internal fission can be useful to reduce (and even deliberately been added through the use of failfactors)

Or you might think about it on the other side Are; If they are all helpless to start with and you insert the data, do you have to reshuffle data on different pages and end up getting index fission?

Yes, assuming that there is not enough free space on the page, so that you can accommodate the long line, you can split the page to create space for new data. The logical sequence will be separated by the physical order and you get the external fragmentation.