Wednesday, December 26, 2012

Check DB Table Size (sp_spaceused)

sp_spaceused
Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.

Example
EXEC sp_spaceused N'Sales.SalesPerson';

Result

9 comments:

Jared Drake said...

Excellent tutorial on table size. I also have written some SQL Tutorials as well. I hope these help anyone looking to learn SQL.

Singer Lee said...

This amazing internet site undoubtedly provides all of the details I wanted regarding this subject as well as didn’t understand who have individuals. buy and sell runescape accounts
rs accounts for sell
buy and sell runescape accounts
runescape accounts sale
runescape accounts buy
rs accounts for sell
buy and sell runescape accounts
runescape accounts sale
runescape accounts buy

Doris Eudora said...

I agree with this article completely, I must thank you for posting such helpful facts.design my logo

paula adams said...

I am extremely impressed thanks for sharing all information.support in dissertation , thesis provider , writing service , pay for accounting help , uk university , written papers

hazel Blossom said...

Excellent post and wonderful blog, I really like this type of interesting articles keep it u. I am really loving the theme/design of your web site.definition essay

GuildWars2Items said...

Of all the wonderful gifts that we've been given, one of the greatest is freedom aion gold, a bumblebee if dropped into an open tumbler will be there until it dies, unless it is taken out aion gold, It never sees the means of escape at the top, but persists in trying to find some way out through the sides near the bottom aion gold.

The past is gone and static. Nothing we can do will change it.scarlet blade gold, the future is before us and dynamic. Everything we do will affect it rs gold, You laugh at mescarlet blade gold for being different , but I laugh at you for being the same.

Hariharan s said...

Nice tutorial for checking Database table size ....

http://www.theosoftindia.com/

Ronal India said...
This comment has been removed by the author.
Ronal India said...
This comment has been removed by the author.