• Lowell (8/7/2012)


    I had a similar interview like laurie had years ago; they were interested in whether I knew vb6, ADO and whether i knew javascript; the questions had a couple of techy questions, but the end of the interview was "can you start tomorrow".

    I took the same interview as Laurie, two or three weeks' before, with the same two interviewers. "Do you know the difference between an inner join and an outer join", "Yes", was the interview. We spent the rest of the allotted time talking about photography. That was the second gig Laurie and I worked. The first was Bravissimo about 4 years ago. Oh, and this is the third, he sits on the same run of desks. The interview wasn't particularly interesting for this one. A fairly rigorous online test followed up a week later by a phone chat about hobbies. Prior to the phone chat, I'd attended an interview with a DM company only a half-hour walk from home. That one was offerred too but the offer came through a day after the offer for this job. Here's the unusual bit - the agent said they'd like me aboard but wanted to haggle over the quoted rate, even though I was putting more on the table than the list of requirements. I'm hoping to discover if it was the client, or the agency scrabbling for a bigger percentage.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden