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?
Write a query to find 5th highest amount paid from the customer table.
What do you understand by physical_only option in dbcc checkdb?
What are the differences between substr and charindex in sql server.
What are relationships and mention different types of relationships in the dbms
What do you understand by integration services in sql server?
What is single-user mode?
What are the differences between ms sql server & oracle?
What part does database design plays a role in performance of an sql server-based application?
What do you understand by replication in sql server? Mention the different types of replication in sql server.