SQL Server Interview Questions (Part 2)

Few days back, i went for an interview , following questions were asked

• How to Performance Tune a Stored Procedure?
• Type of Triggers?
• How to get the old value of a field from a trigger when updating a table?
• What is the difference between horizontal partition and vertical partition?
• if we have three parameters in the where condition (query has the joins with two or more tables table1.filed1=4 and table2.field2=5 and table3.field3=1)
  what will be the Order of execution of the where condition
  Which condition would be executed first i.e. field1 or field2 or field3?
• What are the disadvantages of the cursors?
• A stored procedure has cursors in it, how we can eliminate the cursors?
• What is the difference between temporary table and table variable?
• How to restore the Differential Backup?
• What are Backup Types and difference between them?
• What are Replication Types, What is snapshot replication?
• What is the difference between Replication and Mirroring?
• Can a sub report in Crystal Reports can have another sub report?
• What is log shipping?
• Should we normalize the Database on more than 3rd Normal form?