Post reply

Answers

  • February 17, 2012 at 3:39 am

    #256885

    Hi ,

    Can any one answer these

    1)What is meaning of switch -m and -c when we bring sql server in single user mode?

    2)How can I change the size of page to 16KB instead of 8KB?

    3)How to make secondary server as a primary server manually in log shipping

    4)How to find datafiles location of uncomplete restored db(DB is in restoring mode)?

  • February 17, 2012 at 4:20 am

    #1448392

    Interview?

    -- Gianluca Sartori

  • February 17, 2012 at 4:24 am

    #1448394

    ramyours2003 (2/17/2012)

    Hi ,

    Can any one answer these

    1)What is meaning of switch -m and -c when we bring sql server in single user mode?

    2)How can I change the size of page to 16KB instead of 8KB?

    3)How to make secondary server as a primary server manually in log shipping

    4)How to find datafiles location of uncomplete restored db(DB is in restoring mode)?

    1) -m - starts SQLServer in single-user mode, -c - make SQL Server to startup in less time from command prompt as it doesn't need to start as a service.

    2) You cannot change page size. It's fixed to 8K.

    3) http://msdn.microsoft.com/en-us/library/ms178117.aspx

    4) select * from sys.master_files (in master database and with SA access)

    Now, can I have your job 🙂

    Hornestly, never seen more stupid interview questions. I would reply to all of them except #2. something along the following lines:

    "I'll google it when needed!"

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • February 17, 2012 at 6:34 am

    #1448452

    ramyours2003 (2/17/2012)

    Hi ,

    Can any one answer these

    1)What is meaning of switch -m and -c when we bring sql server in single user mode?

    2)How can I change the size of page to 16KB instead of 8KB?

    3)How to make secondary server as a primary server manually in log shipping

    4)How to find datafiles location of uncomplete restored db(DB is in restoring mode)?

    I'll have to disagree with some of my constituants. These are great System DBA questions and these are the types of questions you need to be ready for during an interview. Now that you have some of these questions, my answer to your question of "can anyone answer these" is "Yes" and it should be YOU! It's time for you to hit the books. Spend some time with Books Online and Google because one of the things a DBA must be able to do is to find answers to such questions on their own. My impression is that you haven't even tried to find the answers on your own yet.

    The purpose of questions 1, 2, and 4 is to find out if you've actually ever done such a thing. You may not have the precise details memorized but you should be able to answer in such a fashion that proves that you've done them before. They're looking for someone who has actually had to do these things so that they don't have to train them. It's like hiring an exhaust mechanic. Just because you've seen a pipe bender, doesn't mean that you've actually used one. The purpose of question 2 is to find out if you actually know the structure of the data and how you can make 8KB pages reference more than 8KB of data.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply