Table size

sp_MStablespace
This undocumented system stored procedure returns the number of rows, data page size (KB), and index page size (KB) for general users.

sp_SpaceUsed
This documented system stored procedure will returns the table size information for DBA.

Both stored procedures may return incorrect information because the sysindexes table may not be current.

DBCC UPDATEUSAGE(0) — report and correct space usage statistics for the current database

DBCC CHECKTABLE(‘tablename’) — check the integrity of data

http://sqlserver2000.databases.aspfaq.com/why-does-sp-spaceused-return-inaccurate-values.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s