December 15, 2011 at 10:45 am
Hello
I need to know how can see on my database the size of only one specific table in MB.
someone could me some help ?
Many thanks
Luis Santos
December 15, 2011 at 10:50 am
Right-click the database in Management Studio, go to Reports -> Standard Reports -> Disk Use by Table. That'll give you the disk space used by each table, and the number of rows in each. Look for the one you want.
Or do you mean inside a query?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 15, 2011 at 11:31 am
Hello
excellent, it was exactly what I needed.
Many thanks
Luis Santos
December 15, 2011 at 11:33 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 15, 2011 at 11:33 am
Hello again
you ask to me "inside a query". That was possible ?
Have you a simple example to see the result for example on Northwind database.
Best regards
Luis Santos
December 15, 2011 at 11:43 am
Try this query:
http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply