Determine Size of a Table in SQL Server

By Lowell Heddings on March 27th, 2007

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.

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 03/27/07
More Articles You Might Like

Enter Your Email Here to Get Access for Free:

Go check your email!