Forum Replies Created

Viewing 15 posts - 631 through 645 (of 2,458 total)

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    g.britton (6/23/2016)

    Alan.B (6/23/2016)

    g.britton (6/23/2016)

    virtually nothing about the subject in SQL Server

    Except for Integration Services that is. Fuzzy Lookup and Fuzzy Grouping use q-grams: n-grams with a distance...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 23, 2016 at 1:16 pm

    #1886610

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    Y.B. (6/23/2016)

    Excellent article! While I've had no need for this yet, I can easily see how this could come in handy one day. Added to my briefcase...looking forward...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 23, 2016 at 11:01 am

    #1886587

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    Eirikur Eiriksson (6/23/2016)

    Nice piece and very good work Alan!

    😎

    Thanks you sir! 😎

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 23, 2016 at 11:00 am

    #1886586

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    g.britton (6/23/2016)

    virtually nothing about the subject in SQL Server

    Except for Integration Services that is. Fuzzy Lookup and Fuzzy Grouping use q-grams: n-grams with a distance component.

    see Fuzzy...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 23, 2016 at 11:00 am

    #1886584

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    David.Poole (6/23/2016)

    Good read. I'm looking forward to the rest of the series.

    Is the CTE tally table to encapsulate the tally table in a single function for when there isn't...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 23, 2016 at 10:38 am

    #1886581

  • RE: New T-SQL Fixed Width "Splitter"

    ChrisM@Work (6/22/2016)

    Excellent writeup Alan, thanks for posting this. I had no idea about n-grams, despite having used them for fuzzy-matching for years.

    Thanks Chris!

    Regarding N-Grams - My second SSC artcicle,...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 22, 2016 at 12:42 pm

    #1886367

  • RE: New T-SQL Fixed Width "Splitter"

    Solomon Rutzky (6/20/2016)

    Hey there. Thanks for the shout-out on SQL#[/url] :-). I like the T-SQL approach and have a few notes (just notes, please don't take any of the following...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 21, 2016 at 1:50 pm

    #1886114

  • RE: Simple CLR request

    Con Alexis thank you sir. That's what I was looking for. Sorry for the late reply, yesterday was my birthday.

    Luis. It's for an article I'm working on. I have a...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 18, 2016 at 12:17 pm

    #1885745

  • RE: PatReplace8K

    manie (6/17/2016)

    Hi Alan,

    Excellent script and thanks a lot for this. I will definitely use it a lot. I would like to go through the script at leisure time and might...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 17, 2016 at 5:36 am

    #1885568

  • RE: Splitting an XML value into multiple rows

    Another way...

    SELECT

    ROW_NUMBER() OVER (ORDER BY x.value('.','varchar(100)')), -- only if you want a row number

    x.query('.')

    FROM #Test t

    CROSS APPLY t.SomeXml.nodes('/Parent') a(x);

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 16, 2016 at 8:18 pm

    #1885526

  • RE: Introduction to U-SQL and Azure Data Lakes

    Good article Mike. Informative, precise and tother the point.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 15, 2016 at 6:39 am

    #1885131

  • RE: First PASS Event

    I was looking for any advice as to how I could get the most out of this event and future ones in terms of technical information exchange

    Forgive me for being...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 14, 2016 at 7:53 pm

    #1885072

  • RE: SQL Calendar Table based on Start and End Date Help

    If you want to make the performance even better you can create a table that stores the required start/end dates and write a function uses it. In the example below...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 14, 2016 at 11:34 am

    #1884975

  • RE: Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

    Great article, I love the series!

    For Microsoft Data Mining you need to purchase the Enterprise or the Business Intelligence Editions.

    Not any more. Now Developer Edition is free for...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 14, 2016 at 8:26 am

    #1884908

  • RE: Generate dynamic multilevel XML file from SQL Server table

    I'm going to see if I can do this. In the meantime, if anyone else wants to try I've created some more usable sample data.

    SET NOCOUNT ON;

    IF OBJECT_ID('tempdb..#Products') ...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

    June 13, 2016 at 8:35 pm

    #1884806

Viewing 15 posts - 631 through 645 (of 2,458 total)