I am considering SQL 2008 R2 trial version on OS windows 2008 web server.
Enabling full-text search function is not accessible through the database properties.
How can I do to enable this feature?
View Complete Post
I need to be able to identify the currently defined stoplist for a given table / full text index. Once I have identified the currently defined stoplist, I need to query it using TSQL to verify if a given word is a stop list word. Is there a good
way to do this using TSQL?
Running SQL 2008
I have installed, uninstalled and installed again MS-SQL 2008 Enterprise on my system. The installation seems to go OK. I used "Select ALL" when I was choosing which components to add. I saw "FullText Search" in that list and it WAS checked for installation.
I'm going through one of those Training Kits (70-433) and I need to install the example databases. One of them "AdventureWorks" requires Full Text Search to install.
I can see "SQL Server FullText Search" in the list of services on my control panel. It's startup type is "Automatic" but it is NOT started. I attempt to start it and I get a message window saying the it could not start it: "Error 3: The system cannot find
the specified path."
When I select the FullText Search and look at its Properties, under the "General Tab", I find that the "Path to Executable" is completely empty.
I have no idea what the command line string should look like or even what the name of the execuatble should be.
I have been rooting through the WEB looking for solutions to this problem. One forum I read said that the file name that I am looking for is MSFTESQL.EXE. I have searched my entire harddrive. That files is NOT THERE. I DID find a file called MSFTE.EXE.
This has been going one for some time. I h
ALTER PROCEDURE [dbo].[SP_SearchTopics]
@keywords varchar(512) = '""'
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT t.*, FTT_T.RANK as 'Rank'
FROM Topic t
INNER JOIN FREETEXTTABLE(Topic, [Name], @keywords) as FTT_T ON t.ID = FTT_T.[KEY]
ORDER BY 'Rank' DESC
When I run sqlmetal on my database, I get this error:
Warning : SQM1014: Unable to extract stored procedure 'dbo.SP_SearchPosts' from SqlServer. Null or empty full-text predicate.
I tried checking the @keywords parameter for null and empty string, but that doesn't work. Any ideas guys?
I have a problem with full text search. It runs very slow. Originaly I thought that our server doesn't have enough memory to cache full text catalog and has to read it from the disk every time. But I ran single containstable statement on the server and it
returned results instantly. So I guess the problem is in joining containstable results with other tables, Views. I understand that containstable runs separately and the query is passed to MS Search Engine which returns results to SQL and merges them
with the rest of the query. But I am not able to figure out what exactly causes the entire query to slow down. I also noticed that Order By rank desc slows down performance even further. But I need to show most relevant results first. Also, similar query without
containstable works quite well. Below is the simplified version of my query along with the execution plan. Please help me to understand/solve this problem. We have SQL 2005 Workgroup edition, Windows 2003 server Standard edition. 4GB ram. Database size
55GB. Full text catalog size 600 Mb.
select top 60
rn = ROW_NUMBER() OVER (ORDER BY key_tbl.rank desc),
productslocation_pid, min(ProductsLocation_price) minprice,
max(ProductsLocation_price) maxprice, count(*) BCNT, rank
from containstable (products, txtcat, 'video') as key_tbl
I have 2 tables one MsgSubject
Issue Description : Keywords from certain folders in the Document Library is not searchable via full text search. For example, the keyword
“4MB7106” is not searchable, even though the document is available in the document library. This is content search in a file in a document library, NOT a file name. Any ideas?