More Interview Questions
Posted by Mike Hillwig
February 9, 2012
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)
SQLServerPedia Syndication
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
No comments yet.
Sorry, the comment form is closed at this time.