Updating multiple tables sql server
In cases where I updated a column that was not a part of the index being rebuilt (as in the examples in this tip), the version store was not used at all.This link also shows exactly which types of locks are acquired during the online index rebuild.A good explanation of these phases can be found here.
First, I want to make sure you understand the difference between rebuilding and reorganizing an index. If you would like to learn more about the differences between the two operations you can read more here.
There is no need to provide extra hardware to support peak workloads, because capacity can be easily added or reallocated from the resource pools as needed. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting access to logical storage structures.