Forum Replies Created

Viewing 15 posts - 17,536 through 17,550 (of 59,098 total)

  • RE: Interview Questions

    Eric M Russell (6/7/2016)

    Jeff Moden (6/7/2016)

    Eric M Russell (6/7/2016)

    So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior level database developer.

    I...

    --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 7, 2016 at 11:59 pm

    #1883792

  • RE: Interview Questions

    Eric M Russell (6/7/2016)

    ChrisM@Work (6/7/2016)

    Eric M Russell (6/7/2016)

    Jeff Moden (6/7/2016)

    Eric M Russell (6/7/2016)

    So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior...

    --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 7, 2016 at 11:54 pm

    #1883791

  • RE: Give me suggestions for DBA interview

    prafuljemail (6/7/2016)

    check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview

    You want way too much information on your signup sheet. And, you're starting to get as annoying as any other...

    --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 7, 2016 at 11:50 pm

    #1883790

  • RE: Regular activities of SQL DBA (L1 person).....

    prafuljemail (6/7/2016)

    check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview

    You want way to much information on your sign up sheet.

    --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 7, 2016 at 11:49 pm

    #1883789

  • RE: Interview questions on SQL Server 2005.

    prafuljemail (6/7/2016)

    you can check interview questions on forums of winmilestone com or winmilestone.com/Topic?Interview

    You want way too much information on your signup sheet.

    --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 7, 2016 at 11:48 pm

    #1883788

  • RE: Questions

    prafuljemail (6/7/2016)

    I have a set of interviews questions which helped many sql server people

    you can check interview questions on forums of winmilestone com / winmilestone.com/Topic?Interview

    Your sign up requires way too...

    --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 7, 2016 at 11:46 pm

    #1883787

  • RE: Nasty Fast PERCENT_RANK

    From the Article:

    Bring on the one million row test harness!!!

    Heh... I love it! It's like a war cry! 😀

    Very cool article, Alan. Well done.

    Hat's off also for...

    --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 7, 2016 at 11:42 pm

    #1883786

  • RE: I am really getting depressed

    prafuljemail (6/7/2016)

    Hi,

    Are you fresher or already left the job ?

    You can try contacting the hr through your friend or colleagues by sharing the resume.

    dont ever loose hope, once you will...

    --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 7, 2016 at 10:56 pm

    #1883782

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/7/2016)

    Hugo Kornelis (6/7/2016)

    GilaMonster (6/7/2016)

    What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if 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)

    June 7, 2016 at 10:53 pm

    #1883781

  • RE: DBA career advice

    prafuljemail (6/7/2016)

    you can prepare for sql interview by trying interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?Interview

    Only if you want to cough up a shedload of information. You want...

    --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 7, 2016 at 10:50 pm

    #1883779

  • RE: Interview Questions

    Ed Wagner (6/7/2016)

    Luis Cazares (6/7/2016)

    Jeff Moden (6/7/2016)

    Luis Cazares (6/7/2016)

    Try this:

    SELECT sys.fn_get_folder(path, 1)

    Absolutely the correct answer! 😛 Well, except for the Hungarian notation used. :hehe:

    That's the MS standard. 😀

    MS...

    --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 7, 2016 at 9:04 am

    #1883630

  • RE: Interview Questions

    Eric M Russell (6/7/2016)

    So I typically bypass the Programming 101 stuff and zoom in on what I really expect from senior level database developer.

    I do expect Senior level Database...

    --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 7, 2016 at 9:03 am

    #1883628

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/7/2016)

    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    It was almost as sarcastic as using LMGTFY but I'm absolutely with 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 7, 2016 at 8:59 am

    #1883622

  • RE: Interview Questions

    vs.satheesh (6/7/2016)

    Hi

    Today i am facing one interview Questions

    I have following folder structure(like string path)

    1) c:\Programmefiles\Dicument\file1.txt

    2) c:\Programmefiles\Dicument\Subdocument\file1.txt

    3) c:\Programmefiles\Dicument\Image\file1.txt

    4) c:\Programmefiles\Dicument\Text\file1.txt

    I want to following output (I want last folder name)

    1)...

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

    #1883614

  • RE: Interview Questions

    Luis Cazares (6/7/2016)

    Try this:

    SELECT sys.fn_get_folder(path, 1)

    Absolutely the correct answer! 😛 Well, except for the Hungarian notation used. :hehe:

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

    #1883609

Viewing 15 posts - 17,536 through 17,550 (of 59,098 total)