• What is fragmentation and how does it affect performance ?

  • How can you improve theperformance of queries that use joins?

  • What are some commonindexing strategies?

  • Explain the concept of query optimization.

  • How do you useindexingtoimprove query performance?

  • Describe the impact of normalization on database performance.

  • What are some techniques for optimizing table design for performance ? Expertise Level of Developer Required to Answer this Question

  • How do you optimize stored procedures for better performance?

  • What are some common wait statistics you look for when troubleshooting performance ?

  • When would you use a clustered index vs. a non-clustered index ?

  • Explain the difference between clustered and non-clustered indexes.

  • How do you identify performance bottlenecks in a SQL Server database ?

  • What are some common causes of performance issues in SQL Server ?