Disk space is an important consideration when you create, rebuild, or drop indexes. Inadequate disk space can degrade performance or even cause the index operation to fail.
Lists index DDL operations that do and do not require additional temporary disk space.
Describes the objects and processes that use temporary disk space during the index operation.
Shows the process of determining the required disk space for offline and online index operations.
Provides recommendations for minimizing the effect of large-scale index operations on the transaction log.
ALTER INDEX (Transact-SQL)
CREATE INDEX (Transact-SQL)
DROP INDEX (Transact-SQL)
Estimating the Size of a Clustered Index
Estimating the Size of a Nonclustered Index
Placing Indexes on Filegroups
Reorganizing and Rebuilding Indexes
