Home Forums SQL Server 2008 SQL Server 2008 - General 100 Most famous interview Questions and Answers RE: 100 Most famous interview Questions and Answers

  • October 29, 2012 at 9:57 pm

    #1553984

    mickyT (10/29/2012)

    {Me} How many columns can a table have?

    {You} 1,024!

    {Me} So why are INSERTs designed to handle up to 4,096 columns?

    {You} {wtf???}

    Something else to go and investigate 😀 Could be a QOTD

    Actually, it could be two questions. One for SQL Server 2005 and one for 2008.

    But this is what I'm talking about. Even if all the answers in such cheat sheets were correct (and I assure you, they are not) and someone were able to recite every single answer without hesitation, they still wouldn't pass a real interview because such cheat sheets don't teach a person how to think and they certainly don't give you "experience" for a senior position.

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