Determine Size of a Table in SQL Server

Ever wonder how big a table really is in your database? You know there are a million rows in the table, but how much space is that really taking? 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:

sp_spaceused 'Tablename'

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.

ncG1vNJzZmivp6x7qbvWraagnZWge6S7zGhqanBfmbK1sdGmoKedXai2u7GMqJ1mmV2prqO4xGagp2Wjprluv8SrrZ6qXw%3D%3D