There are times that I think I know a good bit about SQL Server and then I go to work somewhere that they use it in a different fashion than what I have in the past, whether different aspects of it or in a larger scale. At those times I quickly realize just how much I don't know. So, I find it best to take the role of a perpetual learner and whenever possible share what I have learned.

All that being said, interviews are tough. The interviewer has that experience of their environment and needs, and they can pick what they want to ask. The best thing that we can do is admit when we don't know something but be clear that we can research that immediately following, and if possible let them know what you found. It goes a long way. I know, I've used that before. 🙂

Enjoy. Humility is tasty.