Brandon Leach (3/7/2012)
You could ask them how to find duplicate rows in a table. Possibly even finding the highest id value if the id is an integer column, say perhaps an identity. You should be able to learn a lot about them by how they solve this.
I think this is a good approach.
I'd start by asking them how to solve various issues pertinent to your environment that maybe you have encountered and resolved in the past. It would give a lot of insight.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events