Fulltext

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

Greetings:

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

My Sproc:

ALTER PROCEDURE [dbo].[SP_SearchTopics]
	@keywords varchar(512) = '""'
AS
BEGIN
	-- 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
	
END

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?

Hello,

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.

Eugene.

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
inner j

hi,

I have 2 tables one MsgSubject