Full Text Search - where are system stoplists stored?

  • Comments posted to this topic are about the item Full Text Search - where are system stoplists stored?

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com
    Be courteous. Drive responsibly.

    Follow me on
    Twitter: @sqltwins

  • Surprised at the numbers (3 out of 4 incorrect), for what is a rather simple question.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • A nice easy one for Monday morning.

    I was somewhat surprised to see it before 0100 BST on Sunday, though.

    Tom

  • A nice easy one for Monday morning.

    I was somewhat surprised to see it before 0100 BST on Sunday, though.

    EDIT: Why are there two of this? Is it a consequence of looped time? (See the post two further down.) Will this edit affect both copies?

    Tom

  • Nice question Nakul 🙂

  • Tom.Thomson (8/20/2011)


    A nice easy one for Monday morning.

    I was somewhat surprised to see it before 0100 BST on Sunday, though.

    Tom you must have been accessing the QOD when I had it open using the undocumented command DBCC TimeWarp.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thanks for the great question, learning something new everyday and today is no exception 😀

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

  • This was removed by the editor as SPAM

  • Good question, thanks.

    http://brittcluff.blogspot.com/

  • Thanks for the question!

    I'm curious about the terminology though. The previously used "noise words" did a good job at conveying the meaning of what was being represented. Seems like "stopwords" is less clear as to purpose. Can anyone enlighten me as to why this terminology was chosen?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • A nice easy one for Monday morning.

  • Good question, got it wrong.

    Was it the same in 2005? I thought that we configured the stopwords and thesaurus via text files back in 2005, which is the last time I played with FT search. I remembered reading that there were some major improvements to FT for Denali, so I figured that not much had changed in 2008.

    ah well.



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

  • Thanks for the question!

    -Dan

  • Thomas Abraham (8/22/2011)


    Thanks for the question!

    I'm curious about the terminology though. The previously used "noise words" did a good job at conveying the meaning of what was being represented. Seems like "stopwords" is less clear as to purpose. Can anyone enlighten me as to why this terminology was chosen?

    I totally agree on the term... Noise words makes sense to me, stop words not so much...

    -Dan

  • great question!!! thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

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

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