What is indexed view? How to create it?
What are the two authentication modes in sql server?
How to find the second highest salary of an employee?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are the types of processing and explain each? : sql server analysis services, ssas
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are the purposes of floor and sign functions?
What do you understand by a view? What does the with check option clause for a view do?
What are diverse clauses that form a part of sql?
What is the primary use of the model database?
Do you know what is fill factor and pad index?
What do you understand by triggers and mention the different types of it?
What is inner join in sql server joins?
What are the different types of cursor?
How to rebuild master databse?