Explain the functionalities that views support?
What are xml indexes?
What is the openxml statement in sql server?
What is for xml in sql server?
How to call stored procedure using http soap?
Can you explain what is indexed view? How to create it?
Explain what are partitioned views and distributed partitioned views?
Do you know what are the restrictions that views have to follow?
What are secondary xml indexes?
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?