Forum Replies Created

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

  • RE: Statistical Analysis

    I think this is one of the areas where our profession will grow more and more across the next decade. As we deal with lots of data of varying types,...

    "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 11:52 pm

    #1801468

  • RE: Tuning expensive query III

    You've been around enough to know about posting DLL, sample data, etc... You're also posting the estimated query plan. The actual query plan would be better.

    Anyhow, from a birds-eye...

    "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 11:10 pm

    #1801464

  • RE: REPLACE Multiple Spaces with One

    Gary Harding (5/28/2015)

    Alan.B (5/27/2015)

    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...

    "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:27 pm

    #1801453

  • RE: How to generate week ranges like this picture in sql

    I wrote a numbers function some time ago that is designed for exactly this type of thing.

    IF OBJECT_ID('dbo.GetNumsAB','IF') IS NOT NULL

    DROP FUNCTION dbo.GetNumsAB;

    GO

    CREATE FUNCTION dbo.GetNumsAB(@low int, @high int, @range...

    "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:17 pm

    #1801452

  • 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

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