Forum Replies Created

Viewing 15 posts - 17,491 through 17,505 (of 59,102 total)

  • RE: Interview Questions

    GSquared (6/15/2016)

    And not outrage. Read what you want to into my response. Joe Celko would be proud of you.

    Gosh Gus, who peed in your cheerios today? You...

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

    June 15, 2016 at 3:39 pm

    #1885271

  • RE: Interview Questions

    Eric M Russell (6/15/2016)

    ScottPletcher (6/15/2016)

    Eric M Russell (6/15/2016)

    Jeff Moden (6/14/2016)

    Eric M Russell (6/14/2016)

    You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How...

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

    June 15, 2016 at 3:36 pm

    #1885270

  • RE: Function to convert a datetime value into a harvest season year

    GSquared (6/14/2016)

    I just tested a Calendar table version against the UDFs defined here.

    Calendar table was consistently about 10X faster.

    Can you post your test code?

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

    June 15, 2016 at 9:06 am

    #1885187

  • RE: Function to convert a datetime value into a harvest season year

    joe-584802 (6/14/2016)

    Thanks for the improvement Lynne, I'm guessing table valued functions are more efficient than in-line scalar valued functions?

    Yes and no. There are two types of table valued functions...

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

    June 15, 2016 at 9:03 am

    #1885186

  • RE: Interview Questions

    Lynn Pettis (6/15/2016)

    The only reason I don't think I would not make it through one of your interviews is that no matter how much you assure me that there are...

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

    June 15, 2016 at 8:41 am

    #1885175

  • RE: Interview Questions

    An interview is the one place where volunteering information can do nothing but good... if you know what you're talking about. When someone asks a simple question about how...

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

    June 15, 2016 at 8:39 am

    #1885174

  • RE: Interview Questions

    GSquared (6/15/2016)

    Jeff Moden (6/14/2016)

    GSquared (6/14/2016)

    Jeff Moden (6/10/2016)

    Eric M Russell (6/10/2016)

    Eric M Russell (6/7/2016)

    They're asking the wrong type of questions for a job interview.

    I'm not saying that string manipulation is 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)

    June 15, 2016 at 8:20 am

    #1885166

  • RE: Interview Questions

    ScottPletcher (6/14/2016)

    My advanced knowledge, "tricky" q is:

    In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?

    Edit:...

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

    June 14, 2016 at 10:58 pm

    #1885076

  • RE: Interview Questions

    Eric M Russell (6/14/2016)

    You'll rarely ever be asked pop quiz style questions like "What is a clustered index?" or "How do you get the current date and time?", unless...

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

    June 14, 2016 at 10:44 pm

    #1885075

  • RE: Interview Questions

    GSquared (6/14/2016)

    Jeff Moden (6/10/2016)

    Eric M Russell (6/10/2016)

    Eric M Russell (6/7/2016)

    They're asking the wrong type of questions for a job interview.

    I'm not saying that string manipulation is a bad question. It's...

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

    June 14, 2016 at 10:20 pm

    #1885074

  • RE: Strange Performance Issue

    haridbakorrapati (6/14/2016)

    sorry not able to get answers...

    plz.. ]] mantion whats is ans. and what is qus. guys

    There's not enough information to help. It could be anything and without actual...

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

    June 14, 2016 at 6:18 am

    #1884857

  • RE: Interview Questions

    Sergiy (6/12/2016)

    Man, I can only say - you're dealing with some seriously screwed people. 🙂

    Fakers and Posers and Shammers, Oh my! 😀

    Of course, I cannot know how you define 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)

    June 14, 2016 at 5:58 am

    #1884852

  • RE: FLAG

    Manic Star (6/9/2016)

    patla4u (6/9/2016)

    SELECT TOP 1000 [SubjectID]

    ,[Phase_ID]

    FROM [dbo].[TEST]

    SubjectIDPhase_ID

    1 2

    2 ...

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

    June 13, 2016 at 9:12 pm

    #1884807

  • RE: Copy Database Backup from One Server to Another

    Do any of the backups contain any PII or other sensitive information that probably shouldn't leave the production 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)

    June 13, 2016 at 6:10 pm

    #1884800

  • RE: Restoring a database (without effecting original) - to test the retore process...

    jellybean (6/13/2016)

    Hi,

    Hope this is the right forum. I using SQL Server 2014 and want to test the "restore" process is working correctly. What I wan to do is restore an...

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

    June 13, 2016 at 5:10 pm

    #1884796

Viewing 15 posts - 17,491 through 17,505 (of 59,102 total)