Очень странный результат ...

PavelNK
Дата: 22.02.2010 11:15:26
Запускаю: exec sp_spaceused 'TBl'
Получаю:
name rows reserved data index_size unused
---------- ----- --------- ------- ----------- -------
Tbl 1729 256 KB 136 KB 128 KB -8 KB

Разве такое возможно !!! В BOL ничего про это не написано.

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
Glory
Дата: 22.02.2010 11:18:11
Еще как написано. Прямо в статье про sp_spaceused

When updateusage is specified, the SQL Server 2005 Database Engine scans the data pages in the database and makes any required corrections to the sys.allocation_units and sys.partitions catalog views regarding the storage space used by each table. There are some situations, for example, after an index is dropped, when the space information for the table may not be current. updateusage can take some time to run on large tables or databases. Use updateusage only when you suspect incorrect values are being returned and when the process will not have an adverse effect on other users or processes in the database. If preferred, DBCC UPDATEUSAGE can be run separately.
PavelNK
Дата: 22.02.2010 11:40:22
Огромное спасибо!!! Проморгал!