What is primary key index?
Distinguish between commit and rollback?
what are isolation levels? : Sql server database administration
how would you store your query in an SSRS report or a Database server?
How to make a remote connection in a database?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What do you mean by a Composite primary key?
What are triggers in ms sql server?
Explain what is “asynchronous” communication in sql server service broker?
Can you explain what is the use of custom fields in report?
What is sql server used for?
How do you debug a procedure in sql server?
What happens if time-only values are provided as date and time literals?
What is difference between joins and subqueries?
Do you know data definition language, data control language and data manipulation language?