SQL SERVER – Find Space Used For Any Particular Table

It is very simple to find out the space used by any table in database.

USE AdventureWorks;
GO
EXEC sp_spaceused 'Sales.Customer';
GO

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

9 thoughts on “SQL SERVER – Find Space Used For Any Particular Table

  1. Hi Pinal,

    Is there any way to use replace function for ntext data type. If i want to change a particular text in all columns and all tables in a database. How can i resolved it ?

    Please suggest. Thanks in advanced

  2. Sir m storing image of visitorsand visitor data in a visitor table. The database has become to heavy i doubt its becuz of the size of image is there any way to know the size occupied by a specific column plz. let me know on my email id

  3. Hi Sir,

    Could you please tell me how to write query for “Find Space Used For All Tables in single database or instance level database ”

    Rahulreddy
    [email removed]

  4. Pingback: SQL SERVER – Weekly Series – Memory Lane – #037 | Journey to SQL Authority with Pinal Dave

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