Forum Replies Created

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

  • RE: how to delete non-existent full text catalog

    I am having a similair issue and after the update to sysfulltextcatalog still get the error message. ANy suggestions?

    September 25, 2006 at 4:06 pm

    #662380

  • RE: Clusters and Log Shipping

    Thanks for the information

    February 3, 2006 at 10:05 am

    #618731

  • RE: How do I speed up this DISTINCT statement

    I added the covering key same results. Besides the disk queue length is stuck at between 4 and 12. Until then....waiting on hardware. Thanks for your help.

    January 6, 2006 at 3:40 pm

    #613406

  • RE: How do I speed up this DISTINCT statement

    Looks like the index size grew.

    1. clustered, unique

    name                                       rows        reserved           data               index_size       unused            

    --------------------------------------- ----------- ------------------ ------------------ ------------------ -----------

    PS_KK_ACTIVITY_LOG                        12556668    10376000 KB        4018136 KB         6357624 KB         240 KB

    2. clustered, non-unique

    name                                      ...

    January 5, 2006 at 2:28 pm

    #613045

  • RE: How do I speed up this DISTINCT statement

    StmtText                                                                                                                                                                

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    SELECT DISTINCT H.BUSINESS_UNIT ,A.LEDGER_GROUP FROM PS_KK_ACTIVITY_LOG A ,

     PS_KK_SOURCE_HDR H WHERE H.KK_TRAN_ID = A.KK_TRAN_ID AND H.KK_TRAN_DT

     = A.KK_TRAN_DT

    (1 row(s) affected)

    StmtText                                                                                                                                                                                              

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      |--Hash Match(Aggregate, HASH

    January 5, 2006 at 11:00 am

    #612971

  • RE: How do I speed up this DISTINCT statement

    Well I re-ran a DBCC REINDEXDB on the two tables. Got the time down to 1 minute 15 seconds. Looking at perfmon I am CPU and DISK bound (queue lengths...

    January 5, 2006 at 10:30 am

    #612956

  • RE: How do I speed up this DISTINCT statement

    Here are the indexes. I have run out of ideas to fix.

    PS_KK_ACTIVITY_LOG:

    nonclustered located on PRIMARY - KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN

    nonclustered located on PRIMARY - KK_TRAN_ID, KK_TRAN_DT, LEDGER

    nonclustered located on PRIMARY -...

    January 5, 2006 at 10:18 am

    #612952

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