1. What are the different ways and methods of performance tuning and optimization ? a. Indexing b. Achieving c. Load Balancing d. Query Refactoring e. System/Resource Level Optimization (CPU,Memory,IO Configuration) 2. What is Index ? 3. What is Heap ? 4. What is B-Tree/Balance Tree ? 5. What are the kinds of Indexes ? – Clustered and Non-Clustered 6. What are differences between Clustered and Non-Clustered Indexes ? 7. What is execution plan / query execution plan ? 8. What is Estimated and Actual Execution Plan ? 9. How do you plan about Indexes in your database ? 10. What is difference between Table scan and Index Scan ? 11. What is Composite Index ? 12. What is Filtered Index ? 13. What is Fill Factor ? 14. What is Page Split Problem in Sql Server ? 15. What is Fragmentation , Explain ? 16. What is difference between Index Reo
Connecting, Sharing and Discovering