What is indexed view? How to create it?

586

What are the two authentication modes in sql server?

592

How to find the second highest salary of an employee?

574

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?

469

What are the types of processing and explain each? : sql server analysis services, ssas

729

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?

1711

What are the purposes of floor and sign functions?

522

What do you understand by a view? What does the with check option clause for a view do?

592

What are diverse clauses that form a part of sql?

587

What is the primary use of the model database?

603

Do you know what is fill factor and pad index?

552

What do you understand by triggers and mention the different types of it?

477

What is inner join in sql server joins?

527

What are the different types of cursor?

592

How to rebuild master databse?

647