MSSQL DATABASE INTERVIEW QUESTIONS

What is a clustered index in MSSQL, and how does it work?

What is a non-clustered index in MSSQL?

How do you create a unique index in MSSQL?

What is a filtered index in MSSQL, and when would you use it?

What is a covering index in MSSQL, and how does it benefit queries?

How do you drop an index in MSSQL?

What is a full-text index in MSSQL, and when would you use it?

How does an XML index work in MSSQL?

What are spatial indexes in MSSQL, and when are they useful?

Explain a scenario where using different index types in MSSQL is crucial for a business application and describe how you would implement them.