What are the different SQL Server Versions you have worked on?
How raid can influence database performance?
what is the difference between openrowset and openquery?
What is a view in sql?
What is normalization and what are the advantages of it?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
List out the different types of locks available in sql server?
Explain “row_number()” in sql server with an example?
How can I check that whether automatic statistic update is enabled or not?
Can you index views?
What are the different types of subquery?
Explain system functions or built-in functions? What are different types of system functions?
Why should you use or avoid select * statements?
What are the source of constraints?
How efficient you are in oracle and SQL server?