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 --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • That was a googly :w00t:

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

    Manik
    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 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/

  • 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
    SQL RNNR
    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