Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 2,458 total)

  • RE: The Scientific Method: a call to action

    Brandie Tarvin (5/28/2015)

    Alan.B (5/27/2015)

    Does the lack of deterministic causality invalidate quantum mechanics?

    It Depends.

    Alan, can I just say I adore you right now for putting this together. @=)

    LOVE IT.

    😛

    "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

    May 28, 2015 at 8:03 am

    #1801259

  • RE: The Scientific Method: a call to action

    David Burrows (5/28/2015)

    Jeff Moden (5/24/2015)

    It's funny how people think that. If you get the product out the door and it's broken, you're going to need a whole lot more...

    "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

    May 28, 2015 at 7:55 am

    #1801255

  • RE: Are the posted questions getting worse?

    GilaMonster (5/27/2015)

    SQLRNNR (5/27/2015)

    GilaMonster (5/27/2015)

    Looks like I hit a few nerves with Sunday's editorial....

    Two words...

    Ugh

    Troll

    I'd reply and point out the flaw in his logic (he's got scientific method and scientific consensus...

    "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

    May 27, 2015 at 6:23 pm

    #1801131

  • RE: The Scientific Method: a call to action

    meilenb (5/27/2015)

    Alan.B (5/27/2015)

    Lynn Pettis (5/27/2015)

    meilenb (5/27/2015)

    Alan.B (5/27/2015)

    Emph. mine

    meilenb (5/24/2015)

    ...

    Everyone knows that CO2, CH4 and N2O ...

    How is the science clear on climate change when the scientists can't agree? Plus,...

    "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

    May 27, 2015 at 2:52 pm

    #1801101

  • RE: The Scientific Method: a call to action

    Lynn Pettis (5/27/2015)

    meilenb (5/27/2015)

    Alan.B (5/27/2015)

    Emph. mine

    meilenb (5/24/2015)

    ...

    Everyone knows that CO2, CH4 and N2O ...

    1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree"...

    "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

    May 27, 2015 at 11:57 am

    #1801045

  • RE: The Scientific Method: a call to action

    Does the lack of deterministic causality invalidate quantum mechanics?

    It Depends.

    "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

    May 27, 2015 at 11:55 am

    #1801044

  • RE: REPLACE Multiple Spaces with One

    Michael Meierruth (5/27/2015)

    Alan B.

    How does your function stand up to a varchar(8000) column with an * at the beginning and end and all blanks in between?

    Okay, first - both functions...

    "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

    May 27, 2015 at 11:45 am

    #1801037

  • RE: The Scientific Method: a call to action

    Emph. mine

    meilenb (5/24/2015)

    ...

    Everyone knows that CO2, CH4 and N2O ...

    1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree" are antithetical to 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

    May 27, 2015 at 10:21 am

    #1801008

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/27/2015)

    Just curious how many people on The Thread are World Cup fans. Cause... STUFF and MORE STUFF.

    And I was wondering how y'all felt about it.

    I live in Chicago,...

    "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

    May 27, 2015 at 9:52 am

    #1800996

  • RE: REPLACE Multiple Spaces with One

    Jeff Moden (5/26/2015)

    Alan.B (5/26/2015)

    I love this article Jeff and have been using your technique since I discovered this article a little more than a year ago.

    Thanks, Alan, but you...

    "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

    May 26, 2015 at 9:18 pm

    #1800734

  • RE: REPLACE Multiple Spaces with One

    I love this article Jeff and have been using your technique since I discovered this article a little more than a year ago.

    I was using your technique to create...

    "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

    May 26, 2015 at 4:33 pm

    #1800715

  • RE: Critique My Understanding of Window Functions Please...

    I think you're on the right track, you'll notice in Jason's excellent example that he includes a number in his lag/lead functions (you did not not which is the problem)...

    "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

    May 26, 2015 at 1:48 pm

    #1800696

  • RE: Big Data for SQL folks: The Technologies (Part I)

    This is hands down the best big data article I have read in some time. We'll done sir, very informative yet concise. 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

    May 23, 2015 at 7:40 am

    #1800204

  • RE: SSMS's intelliSense

    Beatrix Kiddo (5/22/2015)

    Ctrl+Shift+R will refresh the Intellisense local cache. (Or Edit > Intellisense > Refresh Local Cache.)

    See if that helps?

    That has never helped me with the problem the op is...

    "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

    May 22, 2015 at 8:20 am

    #1800021

  • RE: Archieving Data

    ramana3327 (5/21/2015)

    I write the sp below and tested. When I tested it is not coming out of loop after the deletion of the records from the Error table.

    Is it performance...

    "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

    May 21, 2015 at 4:34 pm

    #1799854

Viewing 15 posts - 1,441 through 1,455 (of 2,458 total)