Explain log shipping?
What do you understand by the analysis services in sql server?
What are the steps you must follow to hide sql server instances?
What are the advantages of mirroring?
What do you understand by user-defined function in the sql server?
What are the differences between having and where clause.
What are the options which must be set to allow the usage of optimistic models?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Mention the command used to rename the database.
Mention the differences between sql server and mysql.
What are trace flags and mention a few common trace flags used with sql server?
What are subqueries in sql server? Explain its properties.
What do you understand by mirroring?
What are joins in sql and what are the different types of joins?
How can you check the version of sql server?