Timeline for Table Size Analysis on SQL Server 2000
Current License: CC BY-SA 3.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 15, 2014 at 5:27 | comment | added | user37121 | You just need to write following command on query analyzer and run it will remove the spaces whatever table catering user <database name> dbcc shrinkfile ('<Database Name>') | |
| Mar 23, 2013 at 11:46 | comment | added | Marian | I suppose the server is not reporting the correct space used by the tables. You could use the system procedure sp_spaceused (for each table) to see the reported space and if numbers don't match with what you think they should be, then use DBCC UPDATEUSAGE (it will fix the row and page counts). Please read also answer1 and answer2. | |
| Mar 22, 2013 at 19:16 | answer | added | Rice Black | timeline score: 2 | |
| Mar 8, 2013 at 22:37 | history | edited | marc_s | CC BY-SA 3.0 |
added 6 characters in body; edited title
|
| Mar 8, 2013 at 15:25 | comment | added | Marc | There are 3 indexes on BigTable but they're all on trivial int fields. How to explain the 13GB?? | |
| Mar 8, 2013 at 15:22 | comment | added | Marc | Aaron, I get 1838629593 2028217 for tBigtable | |
| Mar 8, 2013 at 15:20 | comment | added | Marc | You mean a disk defrag? Didn't know that would have any influence on the size of a single file. AFAIK our servers are virtual and using SAN technology. | |
| Mar 8, 2013 at 14:00 | comment | added | Marian | For a table of 470 MB you have 13.3 GB of indexes? Do you have an index for every combination of the columns? | |
| Mar 8, 2013 at 13:32 | comment | added | Aaron Bertrand |
So what does select id, reserved from sysindexes order by reserved desc; yield? Also BigTable seems to have 13 GB worth of indexes, so I wonder about your definition of "waste of space"...
|
|
| Mar 8, 2013 at 13:25 | history | migrated | from stackoverflow.com (revisions) | ||
| Mar 8, 2013 at 9:54 | comment | added | Mitch Wheat | when did you last defragment? which service pack? Do you regularly run DBCC CHECKDB? | |
| Mar 8, 2013 at 9:49 | history | asked | Marc | CC BY-SA 3.0 |