More Interview Questions

Leave a comment

February 9, 2012 by Mike Hillwig

I wrote a post many months ago with some interview questions for my old boss to use when searching for my replacement. Tomorrow, we have a candidate interviewing to join our team.  Here are a few things from the top of my head that I just might ask. You’ll need to find your own answers, though.

  • Tell me about VLFs
  • Do you have any experience with MSX-TSX relationships in the SQL Server Agent?
  • How do you maintain INDEXes and STATISTICS in your environment today? How could you improve that?
  • When would you disable auto update of statistics?
  • How do you keep your skills current with SQL Server technology?
  • What’s the most compelling reason to upgrade from SQL 2005 to SQL 2008 R2?
  • What’s the biggest mistake you see other SQL Server DBAs make?
  • What’s your worse habit as a DBA?
  • Are you familiar with the PASS Summit or local chapters?
  • With what trace flags are you familiar?
  • What are the two types of authentication? Which is more secure?
  • Which will be faster, inserting a million rows of data or updating a million rows of data? (shamelessly stolen from Tom LaRock)