Indexl Question 22 April 2010

1. Can we alter the index?
2. Which system are used in very large number of indexing system ?
3. What happened if the clustered index is not unique ?
4. where logged the entry of index in sql server ?
5. what is default sorting order of index?
6. which constraint is created index by default?
7. what is use of DBCC showconfig?
8. How to use fill factor with pad? Explain
9. Explain hash join and merge join ?
10. What is maximum size of row ?