What is update locks?
Determine when an index is appropriate?
Can you explain important index characteristics?
Explain the purpose of indexes?
Explain full-text indexing?
Do you know clustered and non-clustered index?
Explain the difference between clustered and non-clustered index?
Explain having clause and where clause?
Explain indexes disadvantages?
Explain what is it unwise to create wide clustered index keys?
Ms sql server index?
Do you know what is fill factor and pad index?
How to maintain a fill factor in existing indexes?
Write down the syntax and an example for create, rename and delete index?
Tell me the difference between clustered and non-clustered index?