Your search for "full-text-search" returned 100 results:
Hi, I have a weird case with the full text search in Sql Server 2008 R2 SP1 web edition. I have a table that has a row with this value in the indexed field (mapped to a catalog): logitech wireless keyboard case for ipad eran When I query like that, I do get this row […]
2012-12-02
1,356 reads
OK, my first post on a subject I startd learning a couple days ago! SQL2K5 Full Text Search! Right....creating the FTS indexes and catalogs was a no-brainer! I even have a SP that I use to query the indexed table. So my question... What is the best way to search, using FTS, for multiple words? […]
2008-03-29
482 reads
Looking into full-text indexing, I found this warning: "you will encounter performance issues when you reach 1 million rows in the search catalog table." Is the item count, the unique key count, or something else the way to tell how many rows are in the search catalog?Thanks.
2005-01-05
724 reads
Hi, I've been reading up on how to use full-text indexing in SQL Server 2005 following on from my previous post earlier today because I was using LIKE '%' + @Param1 + '%' to perform searching and I'm looking for ways to improve performance. After following Microsoft's documentation, I've managed to enable full text indexing […]
2008-06-01
7,101 reads
Trying to understand why when I search for numerics in full text, contains does not return, but containstable does. It seems that in that in this instance the 0's are repeatable and not indexed, but why does one work and the other not? Is there a way to make it work regardless? CREATE TABLE [dbo].[EquipSrch]( […]
2019-07-18
171 reads
2008-10-06
789 reads
Hello, I manage a website that has the following structure - main database with user information - search database that subscribes to main database publication with transactional replication Both databases run SQL Server 2005. My question is - how do I set up a full text search in the search database? Whenever the replication is […]
2009-10-07
286 reads
I have a table column contains English and French. My FTS always returns something unexpected. I am not sure because of the multi lingual or not. Can someone tell? Thanks
2013-04-18
891 reads
i have set up a data collection to pick up heavy queries on the system, now i want to set up full-text search on the snapshots.trace_data table to query the TextData column better the problem is this snapshots.trace_data doesn't have a unique column, so i made a computed one (i once added a identity column […]
2010-10-19
247 reads
Hi,I wonder if anyone can help me on this one.I'm just getting to grips with 2005 and trying out the Full Text searching.Is there any way that i can weight columns NOT search terms but columns in the index. ie if i searched for "Harry Potter" and it appeared in a title field instead of […]
2006-02-07
449 reads
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
hi all, is there anyway in SQL to getting logged in user name to...
Is there a trigger to notify when a new SQL Agent job is created/modified?
Hello I have a view based upon a number of tables I'm selecting...
In which editions can I use Full-Text and semantic search?
See possible answers