Explain a differential backup?
What are the fixed server level roles? : sql server security
What are a scheduled jobs?
What is the purpose of grouping data in a report?
Explain cross join or cartesian product in sql?
What is the server name in sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How would you add a section to a table?
How each E-R model constructs can be mapped to the relational model?
Explain the advantages of merge replication?
What are different replication agents and what's their purpose? : sql server replication
What are “lost updates”?
What are the dis_advantages of stored procedures, triggers, indexes?
What is self join in sql server joins?
How you can minimize the deadlock situation?