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.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-11-16 : 06:02:14
|
| In sp_spaceused 'table_name'"Unused" shows negative value. Do u know the reason ???will it affect any performance... |
|
|
kishore_pen
Starting Member
49 Posts |
Posted - 2007-11-16 : 06:27:54
|
| see the link: http://msdn2.microsoft.com/en-us/library/ms188776.aspx |
 |
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-11-16 : 06:31:09
|
| This link is not describes the negative value of the unused space |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-11-16 : 17:05:41
|
| You need to 'update usage' I believe. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 01:38:58
|
| That's right, try this:sp_spaceused @updateusage=true, tab_name |
|
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-11-17 : 04:45:49
|
| Fine rmioa ... But i wish to know if it is in negative value mean . wil it affect performance... ??? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 21:46:23
|
| Means usage is out of date, will not affect performance. |
|
|
|
|
|
|
SP_SPACEUSED