How do I find the size of a table?

Question

Post reply

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Paul Mu SSCertifiable Points: 5547 More actions · Answer 1

SSCertifiable

Points: 5547

May 28, 2006 at 11:05 pm

Try sp_spaceused

raj-247939 SSCertifiable Points: 5999 More actions · Answer 2

Hi,

To get the accurate size execute first

sp_updatestats ,dbcc updateusage

then u can use sp_spaceused

or

SELECT [TableName], (SELECT rows FROM sysindexes s WHERE s.indid < 2 AND s.id = OBJECT_ID(a.[TableName])) AS [Rowcount],

[Total_space_used (MB)] From (SELECT QUOTENAME(OBJECT_NAME(i.id)) AS [TableName],CONVERT(numeric(15,2),(((CONVERT(numeric(15,2),

SUM(i.reserved))

*(SELECT low FROM master.dbo.spt_values (NOLOCK) WHERE number = 1 AND type = 'E')) / 1024.)/1024.)) AS [Total_space_used (MB)]

FROM sysindexes i (NOLOCK)Inner Join sysobjects o(NOLOCK) ON i.id = o.id AND (o.type = 'U') AND ((OBJECTPROPERTY(i.id, 'IsMSShipped') = 0))

WHERE indid IN (0, 1, 255)

GROUP BY QUOTENAME(OBJECT_NAME(i.id)) ) as a ORDER BY [Total_space_used (MB)] DESC

from

killer

Rachel Lee-244397 SSC Enthusiast Points: 174 More actions · Answer 3

SSC Enthusiast

Points: 174

May 30, 2006 at 2:44 pm

Thnaks! - both work fine