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

asked Mar 15 '11 at 03:16 AM in Default

pits
830 ● 43 ● 74 ● 83

(comments are locked)

1 answer:

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

answered Mar 15 '11 at 03:16 AM

ThomasRushton ♦
29.4k ● 6 ● 9 ● 36

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 '11 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 '11 at 03:42 AM ThomasRushton ♦

(In case you're not convinced - it is free. Really. And I've used it myself...)

Mar 15 '11 at 04:04 PM ThomasRushton ♦

(comments are locked)