Determine Size Of A Table In Sql Server

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.