Re: reduce time for search query
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 27 Feb 2008 23:16:27 +0100
On Wed, 27 Feb 2008 02:11:16 -0800 (PST), jan.afzal@xxxxxxxxx wrote:
On Feb 27, 3:22 am, Hugo Kornelis(...)
<h...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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
.
- References:
- Re: reduce time for search query
- From: Hugo Kornelis
- Re: reduce time for search query
- From: jan . afzal
- Re: reduce time for search query
- Prev by Date: Using a "match" table to store multiple columns for parent data
- Next by Date: Re: Error on Trigger Launch
- Previous by thread: Re: reduce time for search query
- Next by thread: Deleting a maintenance plan
- Index(es):
Relevant Pages
|
