September 24, 2008 at 12:52 pm
How table reserve space?
September 24, 2008 at 1:11 pm
pls elaborate!!!
Regards,
[font="Verdana"]Sqlfrenzy[/font]
September 25, 2008 at 5:54 am
I was giving bunch of tables and trying to understand a table structure.
Table Name Rows Reserved (KB) Data (KB) Index Size (KB) UnUsed (KB)
Table1 1079450 42066440 KB 5511024 KB 78776 KB 36476640 KB
Is reserved mean how much space in the table left?
September 25, 2008 at 6:27 am
Table Name Rows Reserved (KB) Data (KB) Index Size (KB) UnUsed (KB)
Table1 1079450 42066440 KB 5511024 KB 78776 KB 36476640 KB
Reserved - data - index = unused
Wilfred
The best things in life are the simple things
September 25, 2008 at 6:40 am
Can you reserve yourself?
September 25, 2008 at 6:49 am
I always reserve myself!!! 😎 Table space is different in MS SQL than with some other DB engines. Setup the amount of space for the DB to allow for sufficent growth and you'll be fine (partition if needed). I have yet to come across a need to allocate space for a specific table. What has prompted this question? More detail will get more accurate responses....
-- You can't be late until you show up.
September 25, 2008 at 6:58 am
How do I know how much space to reserve?
Table Name Rows Reserved (KB) Data (KB) Index Size (KB) UnUsed (KB)
Table1 1079450 42066440 KB 5511024 KB 78776 KB 36476640 KB
Table2 609095 34410160 KB 4412056 KB 90936 KB 29907168 KB
Table3 609095 33447480 KB 4351776 KB 46624 KB 29049080 KB
Table4 741589 23550968 KB 3467656 KB 30192 KB 20053120 KB
Table5 521988 4522704 KB 1221448 KB 50880 KB 3250376 KB
I was told that these tables basically, many columns within select tables are allowing NULL values (as a default). No values are entered and because the data types are varchar(X), SQL server is reserving a great deal of space within the database and causing everything to be bloated.
Any suggestions? Thank you
September 25, 2008 at 7:07 am
You can do a DBCC Shrinkfile but I would caution against doing this with any regularity (leads to physical disk fragmentation). MSSQL manages things appropriately - IMO. What are the issues you're facing? Running low on disk space, performance issues? Have you re-indexed your tables? I'd start there to see what space is reclaimed and see what your stats are afterward. Again, what are your concerns?
-- You can't be late until you show up.
September 25, 2008 at 7:34 am
Thank you for your help.My concerns are: I was told that Basically, many columns within select tables are allowing NULL values (as a default). No values are entered and because the data types are varchar(X), SQL server is reserving a great deal of space within the database and causing everything to be bloated. Can varchar do that? I don't think is right
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply