Forum Replies Created

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

  • RE: Looking for an optimal solution

    flownominal16 - Tuesday, December 12, 2017 3:08 PM

    ScottPletcher - Tuesday, December 12, 2017 2:50 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

    December 12, 2017 at 3:14 pm

    #1971850

  • RE: Looking for an optimal solution

    flownominal16 - Tuesday, December 12, 2017 1:58 PM

    Hey all -

    Thanks for the interest.  Unfortunately, my scenario is rigidly as described as far...

    "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 12, 2017 at 3:01 pm

    #1971846

  • RE: Advice for Newcomers

    Do what you love and the money will come; nobody is awesome at stuff they don't like to do - regardless of how well it pays. 

    This has been...

    "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 12, 2017 at 1:51 pm

    #1971838

  • RE: Looking for an optimal solution

    What are you trying to do?

    "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 12, 2017 at 1:40 pm

    #1971835

  • 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

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