View Single Post

   
  #5 (permalink)  
Old 03-01-2008, 03:49 PM
Hugo Kornelis
 
Posts: n/a
Default Re: reduce time for search query

On Wed, 27 Feb 2008 02:11:16 -0800 (PST), jan.afzal@gmail.com wrote:

>On Feb 27, 3:22 am, Hugo Kornelis
><h...@perFact.REMOVETHIS.info.INVALID> wrote:
>> I see lots of useful (and some less useful) idea posted to that topic
>> over at sqlteam.com. Did you already try them? Did they help?

(...)
>Yes we have tried most of them, however, we did not get the required
>results.


Hi jan.afzal,

There is at least one you did not try yet. Posted by Peso:

"Yes. Why don't you give us the present code for review?
Or do you want us to guess?"

Najm already posted a similar request here. I really can't add anything
to what is suggested in that thread without knowing the actual code.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Reply With Quote