Breaking News: Grepper is joining You.com. Read the official announcement!

GET TABLE SIZE IN SQL SERVER

Famous Fish answered on October 12, 2023 Popularity 9/10 Helpfulness 8/10

answer GET TABLE SIZE IN SQL SERVER

GET TABLE SIZE IN SQL SERVER

Comment

USE {Database_Name};
GO 

SELECT
  t.Name                                       AS TableName,
  s.Name                                       AS SchemaName,
  p.Rows                                       AS RowCounts,
  SUM(a.total_pages) * 8                       AS TotalSpaceKB,
  SUM(a.used_pages) * 8                        AS UsedSpaceKB,
  (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM
  sys.tables t
  INNER JOIN sys.indexes i ON t.object_id = i.object_id
  INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id
  INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id
  LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE
  t.Name NOT LIKE 'dt%'
  AND t.is_ms_shipped = 0
  AND i.object_id > 255
GROUP BY
  t.Name, s.Name, p.Rows
ORDER BY
  t.Name;
GO

Popularity 9/10 Helpfulness 8/10 Language sql

Source: ppolyzos.com

Tags: get size sql sql-server

Link to this answer
Share Copy Link

Contributed on Oct 12 2023

Famous Fish

0 Answers Avg Quality 2/10

GET TABLE SIZE IN SQL SERVER

Contents

More Related Answers

GET TABLE SIZE IN SQL SERVER

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.