Forum Replies Created

Viewing 15 posts - 226 through 240 (of 938 total)

  • RE: SQLServerCentral To Take Over PASS

    I kinda figured it was a joke when I saw it yesterday sitting in my inbox -- it definitely caught my attention 🙂 I wasn't able to get the...

  • RE: A Google-like Full Text Search

    Matt (3/30/2009)


    wiseman1982 (3/30/2009)


    Give this a try to change handling of noise words:

    EXEC sp_configure 'show advanced options', 1

    GO

    RECONFIGURE

    GO

    EXEC sp_configure 'transform noise words', 1

    GO

    RECONFIGURE

    GO

    Cheers, that seemed to do the trick, what's all...

  • RE: A Google-like Full Text Search

    james.spibey (3/30/2009)


    Hi Mike,

    Great work! If I wanted to add the word "NOT" as an operator, would I just change

    ExcludeOperator.Rule = Symbol("-")

    to

    ExcludeOperator.Rule = Symbol("-") Or Symbol("not")

    Thanks

    James

    Hi James,

    I can't look into it...

  • RE: XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

    peter larsen (3/18/2009)


    I found the solution.

    Sometimes it helps, when you write your problem down on 'paper'.

    SELECT

    T.c.value('../../@Id[1]','int') AS PropertyId,

    T.c.value('(CountryCode/text())[1]', 'varchar(256)') as CountryCode,

    T.c.value('(Number/text())[1]', 'varchar(256)') as PhoneNumber

    FROM @x.nodes('//Property/PhoneList/Phone') T(c)

    One caveat...

  • RE: A Google-like Full Text Search

    Copyright Info

    Someone asked me about copyright on the source code for this article. I can sum it up in one sentence:

    "Feel free to use the source code however you...

  • RE: A Google-like Full Text Search

    emzero (12/15/2008)


    Is there any possibility to use this using .NET 2.0? Because our project is under 2.0 and developed using VS 2005. We can't push the whole project to 3.5...

  • RE: The Date Dimension in Analysis Services

    Vincent Rainardi (11/29/2008)


    Dear all, I'd like to thank you all for reading this article and also for your comments.

    Hi Mike, when different ranges are required we can create several Named...

  • RE: Functio to get Amount in words.

    TheSQLGuru (10/14/2008)


    That site has a lot of really great stuff. Aaron Bertrand, IIRC.

    And I too think this is a presentation layer item. Or perhaps a CLR function??

    Actually something...

  • RE: The Date Dimension in Analysis Services

    Got the book, reading it now. Great stuff!

    I have a question for you though - I like to have a very large date dimension because the date ranges I...

  • RE: A Google-like Full Text Search

    Hi Carsten,

    Add the characters to the definition of the Terminals (see my previous post above). To keep the definition simple I only used the standard 26-character Latin alphabet.

    Here's an...

  • RE: A Google-like Full Text Search

    Try changing the definition for a Terminal to add a hyphen:

    var Term = new IdentifierTerminal("Term", "!@#$%^*_'.?", "-!@#$%^*_'.?0123456789");

  • RE: A Google-like Full Text Search

    Hi panteluke,

    I think you need to modify the grammar to handle international characters. Right now I use a pretty narrow definition for terminals: basically letters A-Z, a-z, numbers,...

  • RE: A Google-like Full Text Search

    rherubin (11/3/2008)


    Just wondering if you had the code to make the OR operator take precedence over the AND operator in queries? I've tried modifying the SearchGrammar constructor code but...

  • RE: Full-text Search

    Jamie Longstreet (10/17/2008)


    if a thesaurus is consulted new words may be introduced and if it is possible that these words are stopwords then they would need to be processed after...

  • RE: Full-text Search

    Mark Sumner (10/17/2008)


    - it seems to me that you would want to eliminate stop words first, then look at the actual words for example: case sensitivity - it will reduce...

Viewing 15 posts - 226 through 240 (of 938 total)