RE: 100 Most famous interview Questions and Answers

SSC Guru

Points: 1003861

October 29, 2012 at 9:22 pm

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

The answer will be a huge surprise to those not used to this type of questioning... especially if I've already told them that the environmet they'll be working in is 2005 😉

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