SQL Server Performance

replication,security,logshipping,performance interview questions

Discussion in 'Getting Started' started by sqldbarocks, Jan 22, 2011.

  1. sqldbarocks New Member

    Answer the following: it may helpful to newbies who wants their career as a dba
    Sql dba freqently asked questions in interviews:
    what are the dbroles,server roles
    if user wants to update data in a db what dbroles I need to assign to ?
    how I can give permissions to user on only one table in a db ?
    what are the agents involved in merge replication?
    what's the differance between transactional,merge replication? which one suits when>
    what's if log reader is not working in any replication steup?
    what are the differant issues face in your environment on replication(any errors/issues in replication) and how do you fix it?
    what is the purpose of logshipping?
    what are the endpoints in logshipping ?what r the port numbers for logshipping?
    what are the logshipping frequent issues you have faced?
    what are the index types and when you go for cluster index and non cluster index?
    what is fillfactor?
  2. Luis Martin Moderator

    I've moved to relevant forum.
  3. FrankKalis Moderator

    While stuff like the one you've asked for will surely be helpful to newbies, we don't do the homework for you!
    The information is readily available on the internet in lots of places and all yours for the taking.
  4. satya Moderator

    Luis I don't see the point of this thread in Contribution section, most of these are generic & learner based queries, so I would move it to Getting started section which suits well.

Share This Page