SQL Server - Table Size

About

The size attribute is the sys.allocation_units.total_pages as shown in the SQL documentation

SQL

SELECT u.total_pages
FROM sys.allocation_units AS u
         JOIN sys.partitions AS p ON u.container_id = p.hobt_id
         JOIN sys.tables AS t ON p.object_id = t.object_id
WHERE t.name = 'xxx'