Help needed on SQL query for a search function
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help needed on SQL query for a search function

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Help needed on SQL query for a search function

    ..
    Last edited by joelny; 03-10-2008 at 03:19 PM.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Trace the session that is running the search procedure. Post the plan and any associated wait events here, then we might be able to suggest something.

    Google "10046" for information on tracing.
    Assistance is Futile...

Posting Permissions

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



Click Here to Expand Forum to Full Width