|
|
| rupart 2006-02-28, 8:23 pm |
| Hi,
Is there a way to get table size? I want to find out which tabel using the
most space. I saw there is a way to estimate the size with some formula and
calculation but i believe there must be some sp_ or other method to get the
exact and accurate table size.
TIA
| |
| Uri Dimant 2006-02-28, 8:23 pm |
| Hi
sp_spaceused 'tablename'
"rupart" <rupart@discussions.microsoft.com> wrote in message
news:F14619ED-3A25-4161-BEEC- 6E89457C39DA@microso
ft.com...
> Hi,
> Is there a way to get table size? I want to find out which tabel using the
> most space. I saw there is a way to estimate the size with some formula
> and
> calculation but i believe there must be some sp_ or other method to get
> the
> exact and accurate table size.
>
> TIA
| |
| rupart 2006-02-28, 8:23 pm |
| thx Uri,
I wonder why when i run this command, a dialog box prompting me to save the
report in .rpt format. Can't I view in the diplay pane?
I also find out i can check the table size in taskpad view :-)
"Uri Dimant" wrote:
> Hi
> sp_spaceused 'tablename'
>
>
> "rupart" <rupart@discussions.microsoft.com> wrote in message
> news:F14619ED-3A25-4161-BEEC- 6E89457C39DA@microso
ft.com...
>
>
>
| |
| Sreejith G 2006-02-28, 8:23 pm |
| Hit "CTRL+D" in Quer Analyzer to get the result in display grid. Currently
your option is set for file output(CTRL+SHIFT+F)
.
Thanks,
Sree
"rupart" wrote:
[color=darkred]
> thx Uri,
> I wonder why when i run this command, a dialog box prompting me to save the
> report in .rpt format. Can't I view in the diplay pane?
> I also find out i can check the table size in taskpad view :-)
>
> "Uri Dimant" wrote:
>
| |
| rupart 2006-02-28, 8:23 pm |
| yeah...my mistake!
tq guys!
"Sreejith G" wrote:
[color=darkred]
> Hit "CTRL+D" in Quer Analyzer to get the result in display grid. Currently
> your option is set for file output(CTRL+SHIFT+F)
.
>
> Thanks,
> Sree
>
> "rupart" wrote:
>
|
|
|
|