1. Why locking can slow down performance? 2. What do we mean by Rewriting SQL? 3. Describe the different SQL server indexes and when do you use each one. 4. Describe the different type of replications and when each one should be used. Describe with step by step instructions how we can replicate a MS-SQL Server database. 5. What type of lock protects against read? What type of locks protects against updates ? 7. When we try to improve performance, where should we normally start from and why? 8. Briefly define/describe RAID. 9. What is a Materialized View? Does it improve Queries or Updates? What is the name of Materialized Views in SQL Server? 10. Describe the different type of Locks in SQL Server?