What do you mean by an execution plan? Why is it used? How would you view it?
what protocol both networks use? : Sql server database administration
How can you set the threshold at which sql server will generate keysets asynchronously?
what's the difference between delete table and truncate table commands? : Sql server database administration
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is a hint?
What are the types of dml?
How to view existing indexes on an given table using sys.indexes?
Can you please explain the difference between function and stored procedure?
What are the steps you will take to improve performance of a poor performing query?
how many non clustered index in sql server 2008,2010,2012
What is right outer join in sql server joins?
Define the term DML, DDL and DTL?