Thesaurus Files

  • Comments posted to this topic are about the item Thesaurus Files

  • 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:

  • 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 -->[/url]

    Follow me @Twitter

  • That was a googly :w00t:

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

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

  • 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]

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

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

  • This was removed by the editor as SPAM

  • 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.

  • 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?

  • 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 for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns -
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs -
    Understanding and Using APPLY (Part 1) -
    Understanding and Using APPLY (Part 2) -

  • 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]

  • @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:

  • Thanks Steve

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

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

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