What is replace and stuff function in sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is scheduled job and how to create it?
Describe in brief sql server monitoring ways.
Differentiate between delete and truncate.
You want to implement the many-to-many relationship while designing tables. How would you do it?
Why do we need different type of parameter?
What do you mean by acid?
What is rank function?
Explain different types of locks in sql server.
What are the benefits of normalization?
What are distributed partitioned views?
Differentiate between a primary key and a unique key.
Define candidate key, alternate key, and composite key.
Explain indexed views and partitioned view with their syntax.