Forum Replies Created

Viewing 15 posts - 18,511 through 18,525 (of 59,098 total)

  • RE: Crafting Your Resume

    Gary Varga (1/28/2016)

    TheFault (1/28/2016)

    David.Poole (1/27/2016)

    When I'm recruiting I scan for the skills I want, the context and then length of time in each position and any suspicious gaps.

    quote]

    Curious...

    --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 28, 2016 at 7:49 am

    #1854958

  • RE: Best practice for temporary working tables.

    Hugo Kornelis (1/27/2016)

    Disclaimer first: I have never used Oracle. So take the below with a huge helping of salt, please.

    However, I have heard many times that Oracle, unlike SQL Server,...

    --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 28, 2016 at 12:43 am

    #1854875

  • RE: Create Text File from SELECT

    Orlando Colamatteo (1/27/2016)

    What you have here is a multi-record format where the header line has a different column-format than the data lines. T-SQL solutions traditionally have trouble with these as...

    --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 28, 2016 at 12:25 am

    #1854874

  • RE: Need Query to know the SQl server service status

    johnwalker10 (1/27/2016)

    Take a look at this article, hope this will help you out:

    https://www.mssqltips.com/sqlservertip/2609/checking-sql-services-status--an-evolution-part-1/%5B/url%5D

    Thanks for posting that article. Interesting thing in the discussions that occurred on that article... some...

    --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 28, 2016 at 12:14 am

    #1854873

  • RE: Create Text File from SELECT

    Orlando Colamatteo (1/27/2016)

    Jeff Moden (1/26/2016)

    We've actually dismantled all SSIS packages except 1 and we're working on that.

    Funny you mention it. I finished migrating the last process that made use 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)

    January 27, 2016 at 5:11 pm

    #1854842

  • RE: Calendar Table Function

    dietztm (1/27/2016)

    Jeff - Sorry to hear you're having performance issues with your database.

    Our problems are the opposite of yours. We have a lot of pressure for quick turnaround and 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 27, 2016 at 5:06 pm

    #1854840

  • RE: Calendar Table Function

    dietztm (1/26/2016)

    Hi Jeff thanks for your response.

    That recursive CTE I posted was only to generate some test data to demonstrate window functions for the LDOM and FDOM. I chose that...

    --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 27, 2016 at 2:05 pm

    #1854820

  • RE: Disk space

    We put the following on their own drives whenever possible.

    1. C: Operating System with good headroom.

    2. D: Programs

    3. E: Swap File is on a separate drive.

    4. L: LDF...

    --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 27, 2016 at 10:49 am

    #1854781

  • RE: Crafting Your Resume

    Gary Varga (1/27/2016)

    Jeff Moden (1/27/2016)

    Steve Jones - SSC Editor (1/26/2016)

    Gary Varga (1/26/2016)

    Jeff Moden (1/25/2016)

    Heh... according to the interviews I've been conducting for the last several years, people have spent way...

    --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 27, 2016 at 8:39 am

    #1854741

  • RE: Multiple queries in the same stored procedure

    ScottPletcher (1/27/2016)

    Jeff Moden (1/26/2016)

    Manic Star (1/26/2016)

    So we had a development. An SQL MVP at days of .Net told our devs that their beloved UberQueries were ok since the QA cached...

    --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 27, 2016 at 8:02 am

    #1854713

  • RE: Turn Out the Lights

    djackson 22568 (1/27/2016)

    Jeff Moden (1/27/2016)

    Henry B. Stinson (1/27/2016)

    This has gotten way off topic and has become a rant on something not even related to SQL Server.

    Heh... they're just talking about...

    --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 27, 2016 at 7:56 am

    #1854709

  • RE: Turn Out the Lights

    Henry B. Stinson (1/27/2016)

    This has gotten way off topic and has become a rant on something not even related to SQL Server.

    Heh... they're just talking about a different kind 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)

    January 27, 2016 at 7:46 am

    #1854702

  • RE: Crafting Your Resume

    Steve Jones - SSC Editor (1/26/2016)

    Gary Varga (1/26/2016)

    Jeff Moden (1/25/2016)

    Heh... according to the interviews I've been conducting for the last several years, people have spent way too much time crafting...

    --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 27, 2016 at 7:42 am

    #1854700

  • RE: Crafting Your Resume

    mjh 45389 (1/26/2016)

    Eric M Russell (1/26/2016)

    Alan.B (1/26/2016)

    Ivanova (1/26/2016)

    ...

    In the past 6 years I have worked with several guys in their 50s, 60s, 70s including an excellent 79-year old (today)...

    --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 27, 2016 at 7:39 am

    #1854697

  • RE: Crafting Your Resume

    Eric M Russell (1/27/2016)

    mjh 45389 (1/26/2016)

    Eric M Russell (1/26/2016)

    Alan.B (1/26/2016)

    Ivanova (1/26/2016)

    ...

    In the past 6 years I have worked with several guys in their 50s, 60s, 70s including an excellent...

    --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 27, 2016 at 7:36 am

    #1854696

Viewing 15 posts - 18,511 through 18,525 (of 59,098 total)