Good potential job interview question
Sasha Pachev
sasha at asksasha.com
Sat Nov 22 21:32:09 MST 2008
I've just solved a problem and then realized it could serve as a great
job interview question:
You have an auto-generated SQL select query with 1000 or so columns
being selected. Each selected column uses a combination of functions.
One of them uses a combination the SQL server cannot handle. The error
message does not tell you which one. Describe a method to track down
the trouble column in a reasonable amount of real time without
modifying the query generating code or creating an automated tool.
--
Sasha Pachev
AskSasha Linux Consulting
http://asksasha.com
Fast Running Blog.
http://fastrunningblog.com
Run. Blog. Improve. Repeat.
More information about the PLUG
mailing list