.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

fulltext stoplists

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server
 

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

 

 

 




View Complete Post


More Related Resource Links

Is data mining techniques better than using fulltext , soundex , pattern to search records? heres my

  
<!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:27487746; mso-list-template-ids:77652700;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l1 {mso-list-id:297423348; mso-list-type:hybrid; mso-list-template-ids:1760099356 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;} @list l1:level1 {mso-level-tab-stop:66.0

How to exclude xml tags from fulltext search?

  
We have an XML string stored in an ntext column (one tag being named "<Fields>", along with some string values, in a table with a fulltext index. In doing a CONTAINS query, I found that searching on "Fields" returns every record in the table. So I added the string <Fields> to a custom stoplist and attached it to the fulltext index, but now the fulltext index doesn't contain any values for "Fields", either. (must be ignoring the brackets) Is there a way to exclude "<Fields>" without excluding "Fields"?

How to exclude xml tags from fulltext search?

  
We have an XML string stored in an ntext column (one tag being named "<Fields>", along with some string values. In doing a CONTAINS query, I found that searching on "Fields" returns every record in the table. So I added the string <Fields> to a custom stoplist and attached it to the fulltext index, but now the index doesn't contain any values for "Fields", either. (must be ignoring the brackets) Is there a way to exclude "<Fields>" without excluding "Fields"?

Fulltext

  

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?

Regards

Alfredo


SQL 2008 FullText Search will not Start

  

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

SQL Server 2008, SQLMetal and FullText Search

  

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?


Slow fulltext search

  

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

fulltext and like sql server 2006

  

hi,

I have 2 tables one MsgSubject

Unable to perform fulltext search for documents in some folders in an SharePoint Document Library

  

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?


Id

Subject

1

Expedite

2

Price

3

discount

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend