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