Home Forums Career Employers and Employees What if interviewer is wrong? RE: What if interviewer is wrong?

  • July 10, 2014 at 10:25 am

    #1728449

    GilaMonster (7/10/2014)

    Jeff Moden (7/9/2014)

    hoping that you'd explain how your previous company managed to make it so on a 1TB database.

    Maybe I'm missing something, but the way I did it (SQL 2005) when I worked at the bank was DBCC CheckDB ('Database name') with no_infomsgs, all_errormsgs

    DB hit 1.2 TB at its largest, no problems with CheckDB creating its snapshots.

    I would say you're not missing a thing. I think the interviewer was missing something.

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