Full Text Search - where are system stoplists stored?

  • Nakul Vachhrajani

    SSChampion

    Points: 10224

    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

  • Ron McCullough

    SSC Guru

    Points: 63877

    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]

  • TomThomson

    SSC Guru

    Points: 104773

    A nice easy one for Monday morning.

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

    Tom

  • TomThomson

    SSC Guru

    Points: 104773

    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

  • CoolCodeShare

    SSCrazy

    Points: 2584

    Nice question Nakul 🙂

  • Ron McCullough

    SSC Guru

    Points: 63877

    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]

  • DugyC

    Hall of Fame

    Points: 3804

    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

  • Britt Cluff

    SSCertifiable

    Points: 5083

    Good question, thanks.

    http://brittcluff.blogspot.com/

  • Thomas Abraham

    SSChampion

    Points: 10761

    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

  • Mike Is Here

    Hall of Fame

    Points: 3348

    A nice easy one for Monday morning.

  • mtassin

    SSC-Insane

    Points: 23099

    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]

  • skrilla99

    SSCertifiable

    Points: 5795

    Thanks for the question!

    -Dan

  • skrilla99

    SSCertifiable

    Points: 5795

    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

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    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