How can you calculate size of an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application for user-defined tables, global and local temporary tables, indexes, and table variables. About indexes you need to vary about Clustered and Non_Clustered, as with SQL 2005 performing Clustered Index online operation do take fair amount of space in the...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/10/17/calculate-size-of-an-index-for-a-new-database.aspx