• Practicing canned answers for interview questions is not a great idea. What happens if the interviewer has an actual good question that requires a discussion about the topic? Interviews are intended to gain an understanding of the candidates knowledge not how well they can memorize some answers. You might look around the "Question of the day" archives on this site. There have been numerous questions on these topics over the years.

    You might also check your favorite search engine and type in "sql server clustering and mirroring interview questions", you will get a long list of returns.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/