Forum Replies Created

Viewing 15 posts - 33,301 through 33,315 (of 59,099 total)

  • RE: Convert string to datetime

    Actually, taking BitBucket's lead, the following is quite quick... provided you want (and you should want) a real DATETIME datatype.

    SELECT CAST(REPLACE(SomeVarcharDateColumn,' EDT','') AS DATETIME)

    FROM dbo.MillionRowTable

    The real...

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

    July 14, 2011 at 11:30 pm

    #1353189

  • RE: DRI or No DRI?

    {Note to self... add more questions about DRI to the interview questions I ask}

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

    July 14, 2011 at 10:36 pm

    #1353181

  • RE: Study material\dumps for Exam 70-450

    kiran41 (7/14/2011)

    Hi ,

    I need to write the Exam 70-450.

    Kindly send me the study material\dumps for Exam 70-450[PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL...

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

    July 14, 2011 at 10:19 pm

    #1353177

  • RE: How to guesstimate # of recursions?

    Mark Tierney (7/14/2011)

    Hi Folks,

    I have a recursive CTE I am using to determine a hierarchy path. I have used these queries before but am a little foggy on the default...

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

    July 14, 2011 at 10:06 pm

    #1353174

  • RE: INNER JOIN with a String Challenge

    Craig Farrell (7/14/2011)

    Since sargability and index seeking are pretty much out the window, this should work for your join:

    REVERSE( RIGHT( REVERSE( AddressCode), 9)) = ID

    EDIT: Misplaced a parentheses.

    I have to...

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

    July 14, 2011 at 9:57 pm

    #1353172

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    That should run quite a bit faster.

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

    July 14, 2011 at 1:31 pm

    #1353070

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    It's not going to matter... even though I'm seriously disappointed in the performance (as you've measured), the new SUM() is faster than a While Loop, easier to write, does not...

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

    July 14, 2011 at 11:37 am

    #1353002

  • RE: A Little Interviewing Advice

    It's a "dumb" little test to (supposedly) separate people who know how to code from the ones that don't. A whole lot of time has been wasted on 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)

    July 13, 2011 at 5:19 pm

    #1352539

  • RE: A Little Interviewing Advice

    Freddie-304292 (7/13/2011)

    I get really annoyed by interviewers who expect you to know every bit of syntax off the top of your head and don't accept answers like the above. ...

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

    July 13, 2011 at 2:47 pm

    #1352480

  • RE: Concatenating Field Values

    ejoell 66477 (7/13/2011)

    I thought the JOIN(hiddenParameter, ",") would be just what I needed. Unfortunately all I get is a list of "#ERROR". And it still returned one row...

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

    July 13, 2011 at 2:20 pm

    #1352458

  • RE: XP_cmdshell DIR

    The need to double-up on % for the variable is to escape the % because there are other variables that use % as a lead character in batch code.

    Clever use...

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

    July 12, 2011 at 7:49 am

    #1351581

  • RE: Handle NULLs

    opc.three (7/10/2011)

    However when you introduced your test data routine and included a clustered index on each table that's when the practice of creating the tables ahead of time and using...

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

    July 11, 2011 at 8:48 am

    #1351125

  • RE: Handle NULLs

    tfifield (7/8/2011)

    Jeff Moden (7/8/2011)

    Nevyn (7/8/2011)

    Cool stuff, Jeff!

    So do you ever use PIVOT and/or UNPIVOT, or are workarounds almost always better/faster?

    I don't use PIVOT because Cross-Tabs are (usually) both faster and...

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

    July 9, 2011 at 11:35 pm

    #1350793

  • RE: Handle NULLs

    opc.three (7/9/2011)

    The entire set of code with The Dixie Flatline solution modified to work with the concrete test tables:

    I have to ask... is there a reason why you avoid the...

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

    July 9, 2011 at 10:56 pm

    #1350788

  • RE: Mortgage amortization table

    I've found the problem. Precision is lost during the multiplication. SQL Server multiplies differently than Excel does. Excel can handle up to 30 decimal places. When...

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

    July 9, 2011 at 9:53 pm

    #1350787

Viewing 15 posts - 33,301 through 33,315 (of 59,099 total)