sp_spaceused的小问题

Question

sp_spaceused @updateusage = 'TRUE',其中参数@updateusage的作用是什么????

Answer 1

sp_spaceused
显示行数、保留的磁盘空间以及当前数据库中的表所使用的磁盘空间，或显示由整个数据库保留和使用的磁盘空间。语法
sp_spaceused [[@objname =] 'objname']
    [,[@updateusage =] 'updateusage']参数
[@objname =] 'objname'是为其请求空间使用信息（保留和已分配的空间）的表名。objname 的数据类型是 nvarchar(776)，默认设置为 NULL。[@updateusage =] 'updateusage'表示应在数据库内（未指定 objname 时）还是在特定的对象上（指定 objname 时）运行 DBCC UPDATEUSAGE。值可以是 true 或 false。updateusage 的数据类型是 varchar(5)，默认设置为 FALSE。

Answer 2

sp_spaceused
显示行数、保留的磁盘空间以及当前数据库中的表所使用的磁盘空间，或显示由整个数据库保留和使用的磁盘空间。语法
sp_spaceused [[@objname =] 'objname']
    [,[@updateusage =] 'updateusage']参数
[@objname =] 'objname'是为其请求空间使用信息（保留和已分配的空间）的表名。objname 的数据类型是 nvarchar(776)，默认设置为 NULL。[@updateusage =] 'updateusage'表示应在数据库内（未指定 objname 时）还是在特定的对象上（指定 objname 时）运行 DBCC UPDATEUSAGE。值可以是 true 或 false。updateusage 的数据类型是 varchar(5)，默认设置为 FALSE。

Answer 3

USE 数据库名称
GO
EXEC sp_spaceused
EXEC sp_spaceused2database_name                                                                                                                    database_size      unallocated space  
-------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ 
test                                                                                                                             2.94 MB            0.10 MB 
reserved           data               index_size         unused             
------------------ ------------------ ------------------ ------------------ 
1880 KB            1248 KB            424 KB             208 KBname                                                                                                                             rows        reserved           data               index_size         unused             
-------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------ ------------------ ------------------ ------------------ 
test0924a                                                                                                                        3           16 KB              8 KB               8 KB               0 KB
a                                                                                                                                8           16 KB              8 KB               8 KB               0 KB
test4                                                                                                                            8           16 KB              8 KB               8 KB               0 KB
attr                                                                                                                             8           16 KB              8 KB               8 KB               0 KB
Photos                                                                                                                           0           0 KB               0 KB               0 KB               0 KB
H_RegisterIncome                                                                                                                 12637       888 KB             840 KB             8 KB               40 KB
test                                                                                                                             4           16 KB              8 KB               8 KB               0 KB
t_user                                                                                                                           2           16 KB              8 KB               8 KB               0 KB
Course                                                                                                                           5           16 KB              8 KB               8 KB               0 KB
Grade                                                                                                                            10          16 KB              8 KB               8 KB               0 KB
tb1                                                                                                                              2           16 KB              8 KB               8 KB               0 KB
test2                                                                                                                            3           16 KB              8 KB               8 KB               0 KB
test3                                                                                                                            8           16 KB              8 KB               8 KB               0 KB
table1                                                                                                                           0           16 KB              8 KB               8 KB               0 KB
dtproperties                                                                                                                     0           0 KB               0 KB               0 KB               0 KB
table2                                                                                                                           0           16 KB              8 KB               8 KB               0 KB
test1                                                                                                                            0           0 KB               0 KB               0 KB               0 KB
test0924                                                                                                                         3           16 KB              8 KB               8 KB               0 KB

Answer 4

表示应在数据库内（未指定 objname 时）还是在特定的对象上（指定 objname 时）运行 DBCC UPDATEUSAGE。值可以是 true 或 false。updateusage 的数据类型是 varchar(5)，默认设置为 FALSE。