Is it normal for Index size to be three times the size of its corresponding
table in SQL 2005

It does not look normal to me. It may be fragmented

did you run

SELECT * FROM sys.dm_db_index_physical_stats
    (DB_ID(N',<your db name>'), OBJECT_ID(N'<your table table>'), NULL, NULL
, 'DETAILED');

and check the avg_fragmentation_in_percent ?


Show quoteHide quote

Zack wrote:
Its possible for this to occur. If there is a fillfactor set to a low
percentage and the table has little number of columns.

Why is the data in Primary instead of my Partition Scheme?
SQL2000 sp_OACreate 'SQLDMO.SQLServer' memory leak?
isnull logic changes
Splitting existing database into multiple files groups
Additional IP for SQL Cluster
Lines disappear
WSUS--on a test server?
Parameterized adhoc SQL v.s. non-parameterized
How to hide table columns for users without permission in SQL Tool
How to list all tables and their size