List all the types of user-defined functions?
Why use “nolock” in sql server?
Explain primary key in sql server?
What is the filtered index?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How will you go about resolving deadlocks?
What is the difference between osql and query analyzer?
What is a join in sql?
Why use update_statistics command in sql server?
List out the difference between union and union all in sql server?
What are locks in sql?
In what sequence sql statement is processed?
Explain how many types of relationship?
What is de-normalization in sql database administration? Give examples?
List the different types of collation sensitivities in sql server?