Forum Replies Created

Viewing 15 posts - 166 through 180 (of 2,458 total)

  • RE: STRING_SPLIT with no delimiter

    One thing to note - Technically the correct answer would include 
    WHERE [value] <> ''
    ... otherwise the result set for 

    declare @A varchar(100) =...

    "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

    December 11, 2017 at 12:46 pm

    #1971651

  • RE: STRING_SPLIT with no delimiter

    Nice question. Cool trick, well done. I learned something new today.

    "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

    December 11, 2017 at 12:39 pm

    #1971650

  • RE: Split out data from single field that is encoded with new lines

    First, above all else... People who create (n)varchar(max) "Notes" columns need a high-five. In the face. With a chair. But I digress. 

    I don't have a full solution yet...

    "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

    December 5, 2017 at 3:23 pm

    #1970811

  • RE: Mathematics/Algorithms in SQL

    I know that this is an old question bumped back up to the front of the line but I agree that it's an important one. 

    My two cents. With...

    "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

    December 4, 2017 at 3:07 pm

    #1970624

  • RE: Certifying Schools

    You can absolutely be successful in the world of databases without a degree. The level of demand right now is crazy (at least where I live) and it's just going to...

    "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

    November 30, 2017 at 8:51 pm

    #1970212

  • RE: sql to find all references of a particular column in a db?

    I have to do this from often enough that I actually created a snippet. This code searches through all routines (stored procs, functions, triggers) for whatever your are...

    "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

    November 21, 2017 at 9:40 am

    #1969025

  • RE: Automatic Plan Correction

    Jeff Moden - Monday, November 20, 2017 7:04 PM

    Jason A. Long - Monday, November 20, 2017 5:13...

    "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

    November 20, 2017 at 7:11 pm

    #1968930

  • RE: Query taking long time

    ekknaveen - Monday, November 20, 2017 5:43 AM

    It is oracle query. need to find where it is taking long time and how...

    "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

    November 20, 2017 at 8:22 am

    #1968781

  • RE: Force execution plan in a view

    Luis Cazares - Monday, November 20, 2017 7:46 AM

    GilaMonster - Monday, November 20, 2017 7:30 AM
    "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

    November 20, 2017 at 8:03 am

    #1968772

  • RE: Automatic Plan Correction

    Great article, very helpful. Well done Wayne, 5 stars!

    "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

    November 20, 2017 at 7:52 am

    #1968769

  • RE: Should this index be clustered?

    Please forgive me if I'm misunderstanding what you said but I don't get this:

    It's currently a heap with a NC Primary Key, but I feel...

    "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

    November 14, 2017 at 4:36 pm

    #1968106

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

    Jason A. Long - Monday, November 6, 2017 11:46 AM

    Alan - I know I'm a little late to the party (can't believe...

    "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

    November 7, 2017 at 8:51 pm

    #1967080

  • RE: Query

    The "from [Test $G_L Entry]" is is not necessary here:
    Select '' as Code from [Test $G_L Entry]

    You could do this:
    Select '' as...

    "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

    November 6, 2017 at 9:38 am

    #1966823

  • RE: How to find the first recurring character of a string.

    I fixed Chris' Test harness code and my own solution which uses NGrams8K. It was faster. If you understand how NGrams8K works then you know that I essentially re-wrote...
    "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

    November 2, 2017 at 6:32 pm

    #1966514

  • RE: Substring Question

    Jeff Moden - Monday, October 30, 2017 2:59 PM

    Alan.B - Monday, October 30, 2017 2:02 PM
    "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

    October 30, 2017 at 3:34 pm

    #1965867

Viewing 15 posts - 166 through 180 (of 2,458 total)