What do you mean by an execution plan? How would you view it?
What is difference in performance between insert top (n) into table and using top with insert?
what are the disadvantages of cursors? : Sql server database administration
What command is used to create a database in the sql server and how?
What is the use of nvl work?
Can you give an example of Stored Procedure?
How you trouble shoot when any job fails
When to use Inner join & when to use subquery?
What is Full Outer Join?
Define self join in sql server joins?
CTE(common table expression)
How to use transact-sql statements to access the database engine?
What is stored procedures?