Re: DBCC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 13:38:23 -0400

Rena wrote:
> Hi all expert,
> I have a question about the below result.
>
> why 416 rows only in 7 pages , but 231 rows need 9 pages on those
> particular table?
> what does this imply? query sysobjects need less time then
> sysindexes? ....and what information are implied?
>
> Thanks alot.
> Rena.
>
> DBCC results for 'PCISDEV'.
> DBCC results for 'sysobjects'.
> There are 416 rows in 7 pages for object 'sysobjects'.
> DBCC results for 'sysindexes'.
> There are 231 rows in 9 pages for object 'sysindexes'.
> DBCC results for 'syscolumns'.
> There are 5613 rows in 91 pages for object 'syscolumns'.
> DBCC results for 'systypes'.

It just tells you how many data storage pages arae required to store the
total number of rows in the table; Pages are 8K big. Row sizes depend on
how the table is declared and what data resides in variable length
columns. 

-- 
David Gugick
Imceda Software
www.imceda.com