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

  • July 9, 2014 at 9:18 pm

    #1728249

    dan-572483 (7/9/2014)

    Well, I have confirmed with someone still working at my former employer that a DBCC CHECKDB job I set up to run overnight on a 1TB+ production database shows recent run times of 4.5 to 4.8 hours.

    Too bad I may have blown an interview because the interviewer was unaware that DBCC CHECKDB runs against a hidden snapshot to avoid lock-related performance issues and believed it was impossible to run DBCC CHECKDB on a 1TB database in less than 5 hours.

    Perhaps he actually was aware of that fact and was also aware of the fact that sometimes DBCC CHECKDB cannot create the hidden snapshot you speak of and was hoping that you'd explain how your previous company managed to make it so on a 1TB 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)