Re: sql server table size?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Rune Norberg" <runeno@xxxxxxxxxxxxxxxx>
Date: Tue, 11 Oct 2005 22:54:57 +0200

Guess you are wondering about table sizes in the SMS db since you are
posting here? Anyway - below is a script you can run from query analyzer to
find table sizes:

use <name_of_db>
select so.name, si.rows, si.reserved * 8 as "Kb", si.rowmodctr as 'Activity'
from sysindexes si
join sysobjects so on si.id=so.id
where so.type='U' and si.indid in (0,1)
order by si.reserved desc

/Rune

"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:180D16DE-499E-4629-A314-D613DD79EBD2@xxxxxxxxxxxxxxxx
> Does anyone know how to view the size on disk for an individual table in
> sql?
> we have sql 2000.

.

Follow-Ups:
- Re: sql server table size?
  - From: Chris

Prev by Date: RE: Can't compile test mof
Next by Date: Re: Need help for setting proper security rights
Previous by thread: Re: DCOM was unable to communicate with the computer 10.x.x.x
Next by thread: Re: sql server table size?
Index(es):
- Date
- Thread

Relevant Pages

Re: closer, but not quite
... Asking them to run the script in SQL in Query Analyzer should work just fine ... yes this is a transactional publication. ...
(microsoft.public.sqlserver.replication)
Re: update database through SQL script
... Now what I want is to open the sql file from VB, ... Did you look at the code in the Query analyzer from the SQL management tool, ... Script and not normal SQL Statement. ...
(microsoft.public.dotnet.languages.vb)
Re: update database through SQL script
... Did you look at the code in the Query analyzer from the SQL management tool, ... Script and not normal SQL Statement. ... installation package now. ...
(microsoft.public.dotnet.languages.vb)
Can error messages in Query Analyzer be suppressed?
... I want to drop some temporary tables every time I start a script within ... Query Analyzer, so I use 'drop table #worktable'. ... create #worktable (saying that it already exists). ... It seems that SQL ...
(microsoft.public.sqlserver.programming)
RE: Declaring a Variable
... What I am trying to do is to compare the speed at which SQL CE inserts data ... I was just going to run a little script and loop around creating x ammount ... Is it possible to declare a variable in the SQL CE query analyzer. ...
(microsoft.public.sqlserver.ce)