Forum Replies Created

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

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

    johnmackintosh (6/23/2016)

    Thanks for this, highly informative post.

    I had no idea this was possible in SQL Server.

    I've done some text mining work using n-grams using R, but I imagine it will...

    "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 28, 2016 at 12:46 pm

    #1887413

  • RE: Reporting Services - Passing Parm String to Stored Procedure ?

    Smendle (6/27/2016)

    Alan.B (6/24/2016)

    If it's a multi-select then SSRS passes the SSRS parameter values as a comma delimited string.

    If user selects CA then 'CA' is passed to the stored proc....

    "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 27, 2016 at 12:58 pm

    #1887122

  • RE: query performance tuning

    You'll need to post the DDL for the tables you are querying for a better answer. Im not at a SQL Server so I can't look at the execution plan...

    "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 25, 2016 at 7:03 am

    #1886882

  • RE: Reporting Services - Passing Parm String to Stored Procedure ?

    If it's a multi-select then SSRS passes the SSRS parameter values as a comma delimited string.

    If user selects CA then 'CA' is passed to the stored proc. If the...

    "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 24, 2016 at 9:45 am

    #1886782

  • 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

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