January 14, 2005 at 6:47 am
Maybe I have lived in a closet for the last 10+ years but this is the forst time I have come across a database where the indexes take up more space then the data. (Transation system).
data index_size unused
------------------ ------------------ ------------------
1209320 KB 1332760 KB 312 KB
Out of house database build. I had nothing to do with it except being asked why optimaization task fails with the error "transaction log is full.
Just inceased the trans action logs to start.
Anyone exsplain to me why the indexes need to be lareger then the data.
Stacey W. A. Gregerson
January 14, 2005 at 8:11 am
Could need to have sp_updatestats and DBCC UPDATEUSAGE ran. Could be sysindexes is not reflecting properly and this may solve. Try it and let us know.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply