Determining Table sizes in MS-SQL

Hi, I was searching for a query that will give me the size of the table in MS-SQL, here it is.

exec sp_spaceused <tablename>

…gives you…

name rows reserved data index_size unused
<name> 17991232 12636448 KB 11051664 KB 1583816 KB 968 KB


—————————————————
*Free* software is a matter of liberty not price. You should think of “free” as in “free speech”.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s