Part II
If you are going for interview with Microsoft for SQL Server developer position make sure you go through all following topics: Paul Randal from Dev Lead, Microsoft SQL Server Storage Engine has provided this list
1) list the transaction isolation levels supported by SQL Server and describe when the use of each is appropriate
2) define index fragmentation and when its appropriate to remove it
3) explain how to make use of minimal logging mode when loading data into SQL Server
4) explain how to examine the query plan choice and look for performance problems
5) explain how various relational constraints are physically manifested by SQL Server
6) describe how to allow the use of AVG with an indexed view (just posted on this here yesterday)
7) when does SQL Server honor locking hints?
8) what is a deadlock and how do you debug it? What about a live-lock? What are the best practices for avoiding deadlocks?
9) what is proportional fill?
10) what datatypes are not recommended as index keys? Why not?
11) what is a merry-go-round scan?
12) what data validation checks are performed using RPC?
13) why is shrinking a database not a good idea?
14) what is cardinality estimation? List 5 ways to screw it up.
15) what is read-ahead?
to be continue....