Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first phone interview with a guy that
supposedly had 10 years of experience. One of the first questions was
asking about a table with 3 columns, two of which were in the clustered
index. A particular query that referenced all 3 columns had a bookmark
lookup. He asked how to make it run faster.
Now I know it's a loaded question, somewhat, and there are lots of factors, but would you answer like this?
- Build an indexed view
And then mention that you'd need to rebuild the index every night so that changes to the underlying table would show up.
I'm sorry, but I think that either you've substantially misrepresented
yourself or your 10 years involved no problems or actual work and
mostly just holding a title.
It got us thinking about what questions to ask and how to evaluate
someone. We also discussed how you should handle an interview. I wrote
an article (Who Do You Hire?) a few years ago, but it's probably time for an update.