What are the disadvantages of merge replication?
What is replication and database mirroring?
What is shared lock?
Explain the advantages of merge replication?
Explain hostprotectionattribute in sql server 2005?
What is exclusive locks?
What is update locks?
Determine when an index is appropriate?
Can you explain important index characteristics?
Explain the purpose of indexes?
Explain full-text indexing?
Do you know clustered and non-clustered index?
Explain the difference between clustered and non-clustered index?
Explain having clause and where clause?
Explain indexes disadvantages?