What is a covered index?
Why can there be only one clustered index and not more than one?
How to Check if table exists in sql server?
How does using a separate hard drive for several database objects improves performance right away?
What are “unrepeatable reads”?
What is an execution plan? How would you view the execution plan?
What is the cpu pressure?
What is user defined stored procedures?
What is sql server schema compare? How we can compare two database schemas?
What are pessimistic lock and optimistic lock?
What is table constraint?
What is sqlcmd?
Explain activity monitors
What is after dml trigger?
What is dirty read?