Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Phantom Index from ShowContig?

    anyone with any ideas on this?

  • RE: SQL Server not using all of its memory.

    we just implemented AWE here and used /3GB /PAE  We have 8gb of ram quad processors.  Before adding this we were using around 2.8 and it jumped up to 7.6gb ...

  • RE: Phantom Index from ShowContig?

    oh just for the record the logical fragmentation for ttbl_PROPOSAL is sitting at: 99.810249328613281

     

  • RE: Phantom Index from ShowContig?

    select db_name()

    go

    DBCC SHOWCONTIG ('tbl_Proposal')

      WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS

    go

    SELECT * FROM sysindexes where name = 'ttbl_PROPOSAL'

    go

    DBCC INDEXDEFRAG (broadway,tbl_proposal,ttbl_PROPOSAL)

    go

    Results

    broadway

    go

    ObjectName   ObjectId    IndexName  IndexId Level Pages Rows

    tbl_PROPOSAL 813245952 pk_PROPOSAL 1 0 902 NULL 

    tbl_PROPOSAL 813245952 idxProposalADV_ID 2 0 61 NULL 

    tbl_PROPOSAL 813245952 idxProposalCOMP_ID 3 0 77 NULL 

    tbl_PROPOSAL 813245952 idxProposalCT_ID 4 0 77 NULL

    tbl_PROPOSAL 813245952 idxProposalRATE_ID 6 0 67 NULL 

    tbl_PROPOSAL...

  • RE: Phantom Index from ShowContig?

    actually looking a bit farther the index doesn't show up in the sysindexes table.

     

    Any ideas or suggestions?

  • RE: Phantom Index from ShowContig?

    I'm having similar problem.  It may not be a phantom but why doesn't it get optimized with the other indexes?

Viewing 6 posts - 1 through 6 (of 6 total)