locked
How much HDD space and an index possibly use? RRS feed

  • Question

  • I just ran this:

    sp_spaceused

    DB size is 5432MB.

    reserved    data    index_size    unused
    5556408 KB    5336728 KB    1184 KB    218496 KB

    I have only Windows 7 and SQL Server 2014 installed on a 40GB drive.  The data set is somewhat large, but I don't think 5.4GB is huge.  Nevertheless, I keep running out of space when indexing one of the tables (there are only 2 tables).

    Can someone tell me what to look at, to see if the setup is wrong?  I have 12GB free, and I keep running out of space when putting an Index on one single table.

    Thanks!


    Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

    Monday, December 8, 2014 8:37 PM

Answers

All replies