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] <outbind://696-00000000879C9B08D9D9434BB0980BC1C3F44FE364B25100/www.roundtab legroup.com> www.roundtablegroup.com ............................................................................ ............................................. 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. --~--~---------~--~----~------------~-------~--~----~ 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>>
