SQL Server Performance

Some random interview questions - how would you have answered?

Discussion in 'SQL Server-Related Job Postings' started by jaybee, Jul 17, 2008.

  1. jaybee New Member

    Hi all, got an interview coming up next week, here's a few I've been asked in the past, just wanted to get some of my peers experiences!



    1) What is the latest Service Pack for 2K? (4/5 I think) When SP3 comes out for 2K5, when would you apply it?;

    2) Do you use SQL native backup or a 3rd party tool? What considerations did you have about Recovery Models?;

    3) Which maintenance tasks do you have automated? Weekly, it seems to me a DBCC Checkdb is necessary, but what else? Also,
    what daily maintenance do you have in place?

    4) What input can you give on ongoing Windows 2K3 Cluster Management/Maintenance (this is a strange one, but true; I had always thought this was the exclusive province of the Windows Admin - apparently not!

    5) How does ITIL benefit the department in general and databasing in particular? (My answer - more controlled, transparent changes detailing what is carried out by whom to affect what/whom)



    Thanks,



    Jaybee.



  2. ndinakar Member

    [quote user="jaybee"]
    1) What is the latest Service Pack for 2K? (4/5 I think) When SP3 comes out for 2K5, when would you apply it?; [/quote]
    SP4 + hotfix. SQL 2000 is almost out of support btw.
    [quote user="jaybee"]
    2) Do you use SQL native backup or a 3rd party tool? What considerations did you have about Recovery Models?; [/quote]
    This is something you have to answer based on your experience.. because further questions might come up based on what you say..you should know the recovery models...
    [quote user="jaybee"]
    3) Which maintenance tasks do you have automated? Weekly, it seems to me a DBCC Checkdb is necessary, but what else? Also,
    what daily maintenance do you have in place? [/quote]
    again something you should answer from your experience.. usual stuff is reindexing, backups, any custom SSIS stuff.. etc.
    [quote user="jaybee"]
    4) What input can you give on ongoing Windows 2K3 Cluster Management/Maintenance (this is a strange one, but true; I had always thought this was the exclusive province of the Windows Admin - apparently not! [/quote]
    have you worked with clustering? If not you better pass this..
    [quote user="jaybee"]
    5) How does ITIL benefit the department in general and databasing in particular? (My answer - more controlled, transparent changes detailing what is carried out by whom to affect what/whom) [/quote]
    This is a topic in itself..ITL is a framework: get an overview here: http://en.wikipedia.org/wiki/ITIL

Share This Page