Wow, Grant, you're getting some good candidates there.

I've seen many knocked out with the "how do you return the identity value (post 2000)? and what's a bookmark lookup?".

What's more amazing is that many of these candidates were actually DBAs for some other company. Makes me appreciate how resilient and tolerant SQL Server can be.