I'm frequently asked about questions that are asked when interviewing candidates for Sql Server related positions, what topics should be covered, what types of questions should be asked, etc. In spirit of trying to address this as well as a range of basic, intermediate, and advanced level topics, I'm going to begin a series of posts related to just that - interview type questions and answers. We'll start with simple Q/A type things, and as we progress we'll move on to scenario type questions and situational topics (at least as situational as you can get virtually in a blog).
I'm actually going to be providing content to a friend who runs a Sql Server Tips site (www.mssqltips.com), so I'll be posting the questions here and links to the answers - hopefully this will allow you to try and answer the questions without seeing the answers, and then be able to check your answers by following the links. I'll also be posting any scripts used for demo purposes directly here as well...
Each of the posts will start with the "So you think you know SQL..." prefix, followed by the topic of questions/scenarios for the day...the first posting will be following this one shortly.
On a side note, if anyone out there has any questions, scenarios, topics, etc. that you are having trouble answering and/or understanding, please feel free to send me an email or post a comment to any blog post (like this one) with a short description of the issue/question/scenario, and I'll be happy to try and follow-up with a blog post detailing the answer/possibilties/reasoning/etc.
Chad Boyd ~~~ This posting is provided "AS IS" with no warranties, and confers no rights. Use of any included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm.