How do you delete duplicate records in sql server?
Which are the third-party tools used in sql server and why would you use them?
How to write a query with an inner join in ms sql server?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are the characteristics of modern DBMS?
How to use values from other tables in update statements in ms sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Explain triggers?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is resultset concur_updatable?
What is difference between materialized view and view?
What are the different types of collation sensitivity?
What is blocking and how would you troubleshoot it? : sql server database administration
Can group by and orderby be used together?