index calculation utilities 1

[rtantek]

can anyone suggest some utilities to calculate index size.

 

[tlbroadbent]

Check the following link for some information about estimating table and database size. You should be able to use the algorithms provided to create a query or spreadsheet that calculates estimated index size.

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_02_2h45.asp

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.