Published at: 06:06 am - Sunday June 27 2010
One of my standard questions I ask when interviewing a candidate with some database or SQL know how is:
Assume you have a fairly complex select statement operating on some serious tables (tens of millions of rows). The customer complains the SQL statement is to slow. What options would you consider for tuning such a select [...]
Published at: 02:06 pm - Thursday June 18 2009
Everybody who understands the working of a Turing machine and that of SQL understands, that SQL probably isn’t Turing complete, i.e. you can’t use it to build a Turing machine. Yet I’m going to show that you actually can implement a Turing Engine using Oracle SQL.
So for those among you who haven’t studied informatics: “What [...]