x

table size

good day,

is there any way/command to identify the perticular table size occupied on the disk?

I have many tables under database,is there any command to understandy the table which is occupying maximum space or the space occupied by all the tables individually?

rgds
more ▼

asked Mar 15, 2011 at 03:16 AM in Default

pits gravatar image

pits
830 80 91 92

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

sp_spaceused - that procedure takes a parameter for the name of the table you're interested in.

more ▼

answered Mar 15, 2011 at 03:16 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.9k 18 20 44

thaks Thomas,

I have many tables under database,is there any command to understandy the table which is occupying maximum space or the space occupied by all the tables individually?

rgds,
Mar 15, 2011 at 03:28 AM pits
I would get hold of @Matt Whitfield's (Atlantis Interactive)'s tool set: http://www.atlantis-interactive.co.uk/products/dataspaceanalyser/default.aspx
Mar 15, 2011 at 03:42 AM ThomasRushton ♦
(In case you're not convinced - it is free. Really. And I've used it myself...)
Mar 15, 2011 at 04:04 PM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x84
x13

asked: Mar 15, 2011 at 03:16 AM

Seen: 900 times

Last Updated: Mar 15, 2011 at 03:27 AM