Not a direct answer to your question...but...have you used SQL Server Profiler and then Database Engine Tuning Advisor? I'd be sure to do that first before rewriting SQL...
On Tue, Aug 25, 2009 at 1:36 PM, Mark Davis <[email protected]>wrote: > hey guys, > > sorry for the non-cf question. Has anyone implemented full text searching > in sql server 2005? I inherited a slew of very convoluted queries that do > quite a bit of *where field LIKE '%searchTerm%'*. Indexing can only > get so much gain and re-architecting the data is not an option right now. > > anyone care to share some wisdom? > > *Mark Davis **| Developer* > ** > > ** > ......................................................................................................................... > > Round Table Group, Inc. > > (281) 717-4575 > > [email protected] > > www.roundtablegroup.com > > > ......................................................................................................................... > > * * > [image: > https://www.roundtablegroup.com/secure/staff/emailSignature/RTG_logo.bmp]* > * > > *The Leading Authority in Expert Witness Search & **ReferralTM*** > > CONFIDENTIALITY NOTE: This e-mail, and any attachments thereto, is > intended only for use by the addressee(s) named in the message originated by > me and may contain legally privileged and/or confidential information. If > the reader of this message is not the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this email in > error, please notify me immediately by telephone and permanently delete the > original and any copy of the email, and any printout thereof. Thank you. > > > > > -- John Bliss IT Professional @jbliss (t) / http://www.linkedin.com/in/jbliss --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
<<inline: image001.gif>>
![https://www.roundtablegroup.com/secure/staff/emailSignature/RTG_logo.bmp]*](https://www.roundtablegroup.com/secure/staff/emailSignature/RTG_logo.bmp]*){kind=link}