Re: DBCC

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 13:35:49 -0400

Each page is 8KB. The row size in each table will vary. Thus, you end up
with differing numbers of pages, based on row size and number of rows. 

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Rena" <Rena@mail.hongkong.com> wrote in message
news:e6EQ%23CgtEHA.3320@TK2MSFTNGP15.phx.gbl...
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'.

Relevant Pages

  • DBCC
    ... DBCC results for 'sysobjects'. ... DBCC results for 'sysindexes'. ... There are 5613 rows in 91 pages for object 'syscolumns'. ...
    (microsoft.public.sqlserver.server)
  • Re: error 2501 performing dbcc reindex
    ... Can you post the error output, exact DBCC command, and output from ... > databases. ... > the database and are also in the sysobjects. ...
    (microsoft.public.sqlserver.server)
  • Re: EXCEPTION_ACCESS_VIOLATION Error
    ... Judging from your DBCC CHECKDB output, it appears that your sysobjects ... backed up with corruption. ... > Could not read and latch page with latch type SH. ...
    (microsoft.public.sqlserver.server)
  • Error - is not a recognized function name.
    ... >returns int ... syscolumns c, sysobjects o, ...
    (microsoft.public.sqlserver.programming)
  • Re: Hexadecimal to Decimal Conversion
    ... Root and FirstIAM columns in sysindexes. ... > I need the decimal equivalent as I would want to use DBCC PAGE to trace> the Index Pages. ...
    (microsoft.public.sqlserver.programming)
Loading