And now we consider "for it more likely" update "not cluster in connection with heap moving."? On yours the fragmentation at SHRINK all remaining does not concern???
In a pancake, what you were anchored to me with a fragmentation?
Fragmentation a fragmentation, , expenditure CPU...
I had a specific question to the Grandfather under its specific message:
"If on tables in a file there are indexes in certain cases it entails their reorganization".
Now that, will enumerate all what concerns to , but does not concern this phrase?
Its this phrase about update of sheet level not cluster,
We clarified it and are happy.
It not "reorganization" for the index structure changes, the new object does not form, it is a simple update of an index.
Which, for example, happens and at a clustered index key.
Not cluster thus will not be rebuilt, but will be updated
I suggest to answer a companion its question at last
"What demands a DB file?"
A SQL Server DBA myth a day: (9/30) data file shrink does not affect performance