Forum Replies Created

Viewing 15 posts - 18,541 through 18,555 (of 59,098 total)

  • RE: Crafting Your Resume

    Heh... according to the interviews I've been conducting for the last several years, people have spent way too much time crafting their resume instead of learning their craft. :sick:

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

    January 25, 2016 at 4:40 pm

    #1854332

  • RE: Hard Data v Gut Feel

    I guess "It Depends" on what you call a "gut feel". I was recently asked to provide hard evidence that a particular stored procedure was the source of 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)

    January 25, 2016 at 4:34 pm

    #1854330

  • RE: Calendar Table Function

    dietztm (1/25/2016)

    We use a date dimension which has any date we'd want to get other info from and join on the date. If I wanted to do this in memory...

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

    January 25, 2016 at 3:50 pm

    #1854325

  • RE: Convert a Date

    Luis Cazares (1/25/2016)

    That's why we should keep dates as dates until final output. To exchange data from one system to another, if a string representation is absolutely needed (flat files),...

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

    January 25, 2016 at 11:26 am

    #1854249

  • RE: Convert a Date

    On that same note, I've repaired the "big", high ROI performance problems associated with the front end for our company and the users still complain of performance problems. 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)

    January 25, 2016 at 9:42 am

    #1854215

  • RE: Convert a Date

    spaghettidba (1/25/2016)

    Eirikur Eiriksson (1/25/2016)

    spaghettidba (1/25/2016)

    Eirikur Eiriksson (1/25/2016)

    spaghettidba (1/25/2016)

    SQL Server 2012 supports the FORMAT function:

    select format(GETDATE(), 'dd-MMM-YYYY')

    Gianluca, don't use the format function, it has terrible performance.

    😎

    It is a CLR function, so...

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

    January 25, 2016 at 9:30 am

    #1854210

  • RE: Importing Error - Text was truncated...

    VegasL (1/23/2016)

    So I tried with and without malformed data, with and without the regedit changes, and basically all I did was [font="Arial Black"]I added a dummy row of data [/font]in...

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

    January 23, 2016 at 10:03 pm

    #1854048

  • RE: Database restore automate

    Sree Divya (1/22/2016)

    hi,

    i am planning automate my database new from shared backup location,

    the requirement is need to auto pick up the full backup from shared location and do the restores.

    can...

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

    January 22, 2016 at 10:25 pm

    #1853978

  • RE: usp stored procedure prefix

    william.balogh (1/22/2016)

    Wakey wakey, Forum thread. 🙂

    Right back a'cha and welcome aboard.

    Q: But what if the table becomes a view!?

    A: Not a valid excuse anymore. Do some work, and build 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)

    January 22, 2016 at 10:10 pm

    #1853977

  • RE: Sub-Grouping by consecutive rows

    Here's the latest readily consumable data with a couple of comments added for other experimenters...

    --===== Conditionally drop the test table to make reruns in SSMS easier.

    ...

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

    January 22, 2016 at 9:07 pm

    #1853971

  • RE: Sub-Grouping by consecutive rows

    There's no need for the Quirky Update in such a case. The "Difference Between Two Row Numbers" will do it, will be faster that the Quirky Update if 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)

    January 22, 2016 at 8:04 pm

    #1853968

  • RE: Today's Random Word!

    TomThomson (1/22/2016)

    SQLRNNR (1/22/2016)

    Ed Wagner (1/22/2016)

    SQLRNNR (1/22/2016)

    DonlSimpson (1/22/2016)

    SQLRNNR (1/22/2016)

    runt

    squirt

    herder

    Sheep

    Black

    Coal

    Graphene

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

    January 22, 2016 at 7:06 pm

    #1853961

  • RE: Sub-Grouping by consecutive rows

    mishka-723908 (1/22/2016)

    Hello, Thank you for the reply. It did work. This is the way I get the data in the file from a source system and need to properly insert...

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

    January 22, 2016 at 6:56 pm

    #1853960

  • RE: Sub-Grouping by consecutive rows

    Jason A. Long (1/22/2016)

    I think this what you're after... Please note that this much easier on later editions of SQL server using the LAG/LEAD functions...

    Some consumable test data...

    IF OBJECT_ID('tempdb..#temp', 'U')...

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

    January 22, 2016 at 6:48 pm

    #1853957

  • RE: Sub-Grouping by consecutive rows

    mishka-723908 (1/22/2016)

    Hello, Thanks for your reply.

    This will group all the rows where A = 1 and B = Al to one row.

    I only want to sum those up where...

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

    January 22, 2016 at 6:46 pm

    #1853956

Viewing 15 posts - 18,541 through 18,555 (of 59,098 total)