Discussion on:

Message 6 of 8
2 Votes
+ -
Plenty of "what is" questions, but not enough "why" questions
IMHO very few of these questions would help you recruit the best candidate for the role.

When I've sat on an interview panel as the technical representative (along with someone from HR and someone from management) I've always concentrated on the "why" of the technology, above the "what". A candidate with a good memory will be able to recite BOL entries for CTE, View, DBCC etc But only candidates who have actually *used* them would be able to tell you why you would want to; what problem was it that caused Microsoft to spend time building it into SQL Server.

For example, after hearing the reply to the question "what is a CTE?" follow up with "under what circumstances would it be better to use a CTE over a subquery?"

The answer to the second question would be more helpful in separating wheat from chaff.
Posted by jneville.work
2nd Oct