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.
-
Disk Space Requirements for Index DDL Operations
-
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.
-
Index Disk Space Example
-
Shows the process of determining the required disk space for offline and online index operations.
-
Transaction Log Disk Space for 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
Concepts
Implementing Indexes
Help and Information
Getting SQL Server 2008 Assistance