Explain a differential backup?

1007

What are the fixed server level roles? : sql server security

1128

What are a scheduled jobs?

956

What is the purpose of grouping data in a report?

968

Explain cross join or cartesian product in sql?

891

What is the server name in sql server?

1010

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?

1005

How would you add a section to a table?

1044

How each E-R model constructs can be mapped to the relational model?

1003

Explain the advantages of merge replication?

952

What are different replication agents and what's their purpose? : sql server replication

1019

What are “lost updates”?

996

What are the dis_advantages of stored procedures, triggers, indexes?

2226

What is self join in sql server joins?

1059

How you can minimize the deadlock situation?

1042