Please differentiate between a local and a global temporary table?
What is table value parameters (tvp)?
What is a trace frag? Where do we use it?
What are dml (data manipulation language) statements in ms sql server?
What are commit and rollback in sql?
Detail about query optimizer?
Explain the difference between clustered and non-clustered index?
What is a group function explain with an example?
What are different types of join?
What are rest-style architecture's?
Do you know what is a linked server in sql server?
Can we check locks in database? If so, how can we do this lock check?
What do you understand by recursive stored procedures?
What are the purpose of Normalisation?
How to list all login names on the ms sql server?