Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Based on the info using sp_spaceused

rows           reserved    data         index_size  unused

7703020     497944 KB	497968 KB	  16 KB	      -40 KB

I create an noncluster index with a column of numeric(18, 0) that is 9 bytes in size; then the index_size turns into 153064 KB.

How is the # calculated?


share|improve this question
up vote 0 down vote accepted

That looks like you don't have ANY indexes on that table, at all, for the index size to only be 16kb.

After creating your index, each row is consuming a tad over 20 bytes in index space. For 7.7 million rows that seems fairly normal.

For detailed information on how to estimate the index size, see this article here.

Man, I would hate to be running any queries over almost 8 million rows with no indexes...

share|improve this answer
Hi, thanks. I just simplify the question for ease of discussion. – user25414 Dec 22 '09 at 3:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.