• SQLRNNR (3/3/2014)


    phonetictalk (3/2/2014)


    "I've encountered DBAs who seemed ill equipped to administer a home grocery list and checkbook"

    This made me laugh out loud. Thankfully I haven't encountered such DBAs.

    Yeah that is funny until you come across those DBAs. I have come across more than my share of them as well.

    Out of the 20 or so "devleopers" and the 4 "dbas" I've interviewed in the last 2 years or so, only 4 (we got two recently) of the developers knew how to get the current date and time using T-SQL. None of the DBAs knew. Also, none of the DBAs knew the difference between a Clustered Index and a Non-Clustered Index nor how to do native backups.

    According to their resumes, these are people that all claim to have at least 5 years of experience (most of the DBAs were closer to 10 years of experience) and all of the DBA resumes claimed expertise in "tuning queries".

    I thought I'd get over being sick about it but these people have been working in what I believe to be some fairly critical companies. I don't know how they surived for as long as they did and I'm still sick about it because there are more like them out there taking "care" of medical records, payroll, etc, etc.

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