• Kingston Dhasian (9/18/2012)


    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.

    Some of these questions seem valid to me as well

    From your questions I feel that either

    1. The interview panel was not experienced one and they have used "Google" to find "SQL Server Interview Questions" themselves OR

    2. This is just an initial round

    Anyways, your answers seem a bit rude to me in an interview

    You could have politely said, "I don't remember the exact syntax as there is always Google and MSDN to help me out"

    I have said this in some interviews and they were OK with it and say that they are only interested in the logic I use to solve the problem.

    +1

    I think the questions were quite appropriate for the position. If someone had told me to "Google" it in an interview, I'd have given them a military escort off the property right then and there.

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