Two bits
I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I will just give them some bad code and have them fix it. Amazing how efficient this is at separating the talent.
I also like to ask about set based v RBAR (thx Jeff Moden) to see if they understand the concept of using batches in SQL.
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