Forum Replies Created

Viewing 15 posts - 10,636 through 10,650 (of 59,095 total)

  • RE: Column names on INNER JOINS

    ANSI/ISO standards have absolutely nothing to do with how to post a question.  They also frequently don't have much to do with high performance code because, if you follow them,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 11, 2018 at 1:59 pm

    #2013144

  • RE: SELECT TOP 1 on Primary Key?

    AdrianLParker+sqlservercentral.com - Friday, November 9, 2018 10:12 AM

    The MSDN says of OPTIONA (FAST X):

    Specifies that the query is optimized for fast retrieval...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 11, 2018 at 1:43 pm

    #2013143

  • RE: Are the posted questions getting worse?

    Michael L John - Sunday, November 11, 2018 12:37 PM

    About 5 miles. We finished just under 22 hours after we started. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 11, 2018 at 1:26 pm

    #2013141

  • RE: Julian Date

    p.s.  And sorry about the mess the forum software made with the code and the results.  I posted it the same way I did in similar posts above but it...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 11, 2018 at 8:52 am

    #2013121

  • RE: Julian Date

    Jeff Moden - Saturday, November 10, 2018 9:41 PM

    frederico_fonseca - Saturday, November 10, 2018 2:06 PM

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 11, 2018 at 8:50 am

    #2013120

  • RE: Are the posted questions getting worse?

    Michael L John - Saturday, November 10, 2018 2:43 PM

    We started moving our data center last night at 3 am. 12 racks...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 10:00 pm

    #2013116

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 1:32 PM

    Jeff Moden - Saturday, November 10, 2018 1:24 PM

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 9:44 pm

    #2013115

  • RE: Julian Date

    frederico_fonseca - Saturday, November 10, 2018 2:06 PM

    similar results for me 

    As the results I had given before only related to the date...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 9:41 pm

    #2013114

  • RE: Julian Date

    jcelko212 32090 - Saturday, November 10, 2018 2:54 PM

    irehman - Saturday, November 10, 2018 8:25 AM

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 9:37 pm

    #2013113

  • RE: Julian Date

    Ok... so nothing has changed much in the last couple of decades for this type of conversion.  A trip through character based code to do such conversions is still a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 1:36 pm

    #2013103

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 12:49 PM

    Jeff Moden - Saturday, November 10, 2018 9:23 AM

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 1:24 pm

    #2013101

  • RE: Julian Date

    Thanks, Frederico.  Time for some play.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 11:30 am

    #2013088

  • RE: Julian Date

    Can we see the code you used to generate the test data?  My concern is that it may have a cardinality of "1" and that can lead to some pretty...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 10:48 am

    #2013086

  • RE: The Cost of Switching

    Back to the subject of "switching", I've found that there are several hidden costs to making such switches.  The single greatest loss (IMHO) is "Lost Learning" and the "art" of...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 10:04 am

    #2013082

  • RE: Julian Date

    frederico_fonseca - Saturday, November 10, 2018 9:31 AM

    one other option (and there are more)

    declare @tbl table
      ( juldate decimal(18, 0)
     ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 10, 2018 at 9:53 am

    #2013080

Viewing 15 posts - 10,636 through 10,650 (of 59,095 total)