Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  peculiar full text queries

Author  Topic  taladon Starting Member 1 Post Posted - 2008-03-17 : 07:22:22 Hello all. I have a website where users can look up their property with an address lookup. I am using a full text index on the street address. For the most part, this works fine, but there are a few things the user can enter on the webpage which makes the query eat 25% cpu (quad core box), and not return results. The query is as follows: select pid, name1, name2, name3, staddr from dl65 where contains(staddr, '"arlington n.e.*" and "1464"') order by pid I have not had a chance to let the query run and get an execution plan since the site and server are busy during most of the day. Any help is appreciated. --John Jackson --Deputy Auditor --http://www.franklincountyauditor.com