Confusing Index size

Question

Post reply

Confusing Index size

sunny.tjk

SSCertifiable

Points: 5041
More actions
August 23, 2011 at 10:31 pm

#246781

Here are the results when I ran sp_spaceused on a table:
TableName Rows Reserved Data Index_size Unused
ABC_table name11886865 4140760 KB 2780792 KB-1243840 KB2603808 KB
Could someone please explain why I got -1243840 for Index size? What does minus sign indicate here?
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

What kind of indexes do you have on that table?

Also, you have by chance shrunk the database recently have you?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Run DBCC UpdateUsage

This DB has been upgraded from SQL 2000?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sunny.tjk SSCertifiable Points: 5041 More actions · Answer 3

SQLRNNR (8/23/2011)
What kind of indexes do you have on that table?
Also, you have by chance shrunk the database recently have you?

Both Clustered and Non clustured.

sunny.tjk SSCertifiable Points: 5041 More actions · Answer 4

GilaMonster (8/24/2011)
Run DBCC UpdateUsage
This DB has been upgraded from SQL 2000?

Sorry, I just have read permissions to the database.

No, the database hasn't been upgraded yet.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

sunny.tjk (8/26/2011)
GilaMonster (8/24/2011)
Run DBCC UpdateUsage
This DB has been upgraded from SQL 2000?
Sorry, I just have read permissions to the database.

So ask someone who has rights to run it

No, the database hasn't been upgraded yet.

Why are you posting SQL 2000 questions in the SQL 2005 forums?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sunny.tjk SSCertifiable Points: 5041 More actions · Answer 6

GilaMonster (8/26/2011)
sunny.tjk (8/26/2011)
GilaMonster (8/24/2011)
Run DBCC UpdateUsage
This DB has been upgraded from SQL 2000?
Sorry, I just have read permissions to the database.
So ask someone who has rights to run it
No, the database hasn't been upgraded yet.
Why are you posting SQL 2000 questions in the SQL 2005 forums?

My bad, didn't realize while I was posting it.