When you need to determine the size of a table in SQL Server, you can use the following query: SELECT TABLE_NAME, MAX(TABLE_SIZE) as MaxSize FROM sys.tables ..
SQL Server provides a built-in stored procedure that you can run to easily show the size of a table, including the size of the indexes… which might surprise you.
Syntax:
Here’s an example of it in action:
Highly useful stuff. It’s always interesting to see that the indexes are bigger than the actual data.
