Space Used By Table

• Eric Wahner-345205

  Mr or Mrs. 500

  Points: 544

  More actions

  February 18, 2009 at 5:23 pm

  #218671

  Comments posted to this topic are about the item Space Used By Table

• WILLIAM MITCHELL

  SSChampion

  Points: 13766

  More actions

  March 4, 2009 at 5:37 am

  #953037

  Another way to do it. . .

  CREATE TABLE #temp

  (

  [name] nvarchar(128),

  [rows] char(11),

  [reserved] varchar(18),

  [data] varchar(18),

  [index_size] varchar(18),

  [unused] varchar(18)

  )

  INSERT INTO #temp

  EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?' "

  SELECT

  [name] AS TableName,

  CAST([rows] AS int) AS NumOfRows,

  CAST(REPLACE([reserved],' KB','') AS int) AS [TotalKB]

  FROM

  #temp

  ORDER BY 3 DESC

  SELECT SUM(CAST(REPLACE([reserved],' KB','') AS int)) AS TotalKB_data FROM #temp

  DROP TABLE #temp