- 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?
Monday, March 7, 2011
SQL Server Interview Questions (Part 2)
Few days back, i went for an interview , following questions were asked