Table size

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

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


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s