RSS Feed

More Interview Questions

2

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)

2 comments »

  1. Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

  2. erjilopterin says:

    Hello my loved one! I wish to say that this article is amazing, nice written and include approximately all important infos. I would like to peer more posts like this .

Leave a Reply

Your email address will not be published. Required fields are marked *

Search

Pages