Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    chicago, il
    Posts
    1

    Question Unanswered: can you really stump QA

    hey all,
    I've got a massive query with a mad amount of conditions in several "WHERE XFIELD IN ('blah','blah2','blah3.....)" but it's on
    a denormalized table so there's no joins - all the data is right there and better yet, I've even recently tried creating a covering index for the query with and without index hints...but it times out or tells me there is insufficient memory to complete the operation - EVEN when I'm only asking for an 'estimated query plan', not even the data itself.

    can we really just break QA with a long query? any suggestions?

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    I got some replies some month ago about a time-out problem, such as:

    - Tools >> Options>> Connections, change the setting from the
    default of 15 seconds to 0.

    - Make sure you have SP2 and MDAC 2.6

    - You can set something called Remote Query Timeout in E.M. (I think it's on server's properties)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •