Thesaurus Files

Question

Post reply

Thesaurus Files

Steve Jones - SSC Editor

SSC Guru

Points: 736270
More actions
February 7, 2013 at 8:55 pm

#100870

Comments posted to this topic are about the item Thesaurus Files
February 8, 2013 at 3:42 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

demonfox SSCertifiable Points: 6289 More actions · Answer 1

I had to read the whole about thesarus files , to get that right ..

good learning for me .. I never used it , I guess I need to know the usage perspective too ...

Thanks for the question Steve ;

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:

Lokesh Vij SSChampion Points: 10836 More actions · Answer 2

Thank you Steve.

Got this correct as I have recently read your blog on "Full-Text Search – Thesaurus"[/url] 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

arun1_m1 SSCommitted Points: 1949 More actions · Answer 3

arun1_m1

SSCommitted

Points: 1949

February 8, 2013 at 12:18 am

#1585766

That was a googly :w00t:

manik_anu SSCrazy Points: 2377 More actions · Answer 4

nice question.. thanks steve...:-)

Manik
You cannot get to the top by sitting on your bottom.

DugyC Hall of Fame Points: 3804 More actions · Answer 5

arun1_m1 (2/8/2013)
That was a googly :w00t:

+1 :Whistling:

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

call.copse SSCoach Points: 18053 More actions · Answer 6

No, I didn't see that coming, fortunately realised I knew nothing about it and did the legwork.

Rich Weissler Hall of Fame Points: 3286 More actions · Answer 7

hehe... Good question. I remember experiencing this one while trying to help someone with the file last summer. 🙂 Good times.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

Awesome question, Steve.

Never knew of this until now and while checking the BOL I came across the section "to edit the thesaurus file.." and in 2nd point it states;

If you are editing the thesaurus file for the first time, remove the following comment lines at the beginning and end of the file, respectively:

and picked 4 thinking it might be the case, and yes, it was correct. This is interesting, need to dig bit deeper. 🙂

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

sestell1 SSChampion Points: 10230 More actions · Answer 9

Nice question!

Full text indexing isn't something I use... had to do a bit of research on this one.

Based on what I read, it looks like even if you had removed the comment lines from the beginning and end of the file, you would also have to use sp_fulltext_load_thesaurus_file to get SQL Server to parse the updated file. Is that the case?

Sean Lange SSC Guru Points: 286590 More actions · Answer 10

Great question. I don't do much with full text indexing but that is going to change for a project in the very near future so the timeliness was good for me. Thank Steve.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

mtassin SSC-Insane Points: 23099 More actions · Answer 11

I remembered this from past forays into Thesaurus files and trying to load them before.

thanks for the brush up!

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Venkat Jonnalagadda Mr or Mrs. 500 Points: 510 More actions · Answer 12

@sestell1

From what I read in BOL, the first time a full text query uses an updated thesaurus file, it automatically loads the thesaurus file.. I have to check if it does so by calling sp_fulltext_load_thesaurus_file or if there is any other way...

___________________________________________________________________
If I can answer a question then anyone can answer it..trying to reverse the logic.. :hehe:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Thanks Steve

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events