Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 0KB unused in some tables. is it problem?

Author  Topic 

jch04
Starting Member

9 Posts

Posted - 2009-02-23 : 05:37:18
0KB unused in some tables. is it problem?
Hello to all community,

I would like to ask whether it is good or not
to have 0KB unused space on some tables.

Here are some results from the execution of sp_spaceunused:

name rows reserved data index_size unused
Table 1 3 24KB 8KB 16KB 0KB
Table 2 450 48 16 32 0KB
Table 3 372 56 24 32 0K

many thanks in advance,

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-23 : 06:34:48
Read this
http://msdn.microsoft.com/en-us/library/ms188776.aspx
Go to Top of Page

jch04
Starting Member

9 Posts

Posted - 2009-02-23 : 10:47:03
Ok should I do something for this?

is is good?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-23 : 11:00:33
quote:
Originally posted by jch04

Ok should I do something for this?

is is good?


Nothing.You rows are too less.
Go to Top of Page
   

- Advertisement -