I use Profiler and Tuning Advisor about once a month to check for bottlenecks. The db is pretty healthy, but we have certain queries that cause issues just because of how they are doing wildcard searches of lots of text. Thanks!
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. _____ From: [email protected] [mailto:[email protected]] On Behalf Of John M Bliss Sent: Tuesday, August 25, 2009 1:40 PM To: [email protected] Subject: [houcfug] Re: full text search in sql server 2005 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 ............................................................................ ............................................. 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>>
<<inline: image001.gif>>
