Estimating the Size of a Table
MSDN Home
MSDN
MSDN Library
Servers and Enterprise Develop ...
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Development
Designing and Implementing Str ...
Databases
Designing Databases
Estimating the Size of a Datab ...
Estimating the Size of a Da ...
Estimating the Size of a Table
Estimating the Size of a Clust ...
Estimating the Size of a Noncl ...
Estimating the Size of a Heap
Switch View :
Classic
Lightweight Beta
ScriptFree
Feedback
SQL Server 2008 Books Online (October 2009)
Estimating the Size of a Table
You can use the following steps to estimate the amount of space required to store data in a table:
Calculate the space required for the heap or clustered index following the instructions in
Estimating the Size of a Heap
or
Estimating the Size of a Clustered Index
.
For each nonclustered index, calculate the space required for it by following the instructions in
Estimating the Size of a Nonclustered Index
.
Add the values calculated in steps 1 and 2.
See Also
Concepts
Estimating the Size of a Heap
Estimating the Size of a Clustered Index
Estimating the Size of a Nonclustered Index
Other Resources
Table and Index Organization
Designing Tables
Estimating the Size of a Database
Help and Information
Getting SQL Server 2008 Assistance
Tags :