• rhythmk (9/18/2012)


    Recently I attended an interview for a role of Senior SQL Developer and I wondered the kind of questions panel asked.Here are few of them.

    1.How many columns a SQL table can hold.

    2.How many string functions are there in SQL.

    3.How many non-clustered indexes a SQL table can have.

    4.What is the port to be used to connect SQL DB server.

    Then they started asking questions on syntax of SQL function.

    At last to stop them I just denied to reply the question by saying that why are you hiring me better to have a Google search for that 🙂

    Did you actually want the job? How did you reply the to questions above?

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