Performance Tuning has been my favorite subject and I have done it for many years now. Today I will list one of the most common conversation about Index I have heard in my life.

Every single time, I am at consultation for performance tuning I hear following conversation among various team members. I want to ask you, does this kind of conversation happens in your organization?

Any way, If you think Index solves all of your performance problem I think it is not true. There are many other reason one has to consider along with Indexes. For example I consider following various topic one need to understand for performance tuning.

• ?Logical Query Processing
• ?Efficient Join Techniques
• ?Query Tuning Considerations
• ?Avoiding Common Performance Tuning Issues
• Statistics and Best Practices
• ?TempDB Tuning
• ?Hardware Planning
• ?Understanding Query Processor
• ?Using SQL Server 2005 and 2008 Updated Feature Sets
• ?CPU, Memory, I/O Bottleneck
• Index Tuning (of course)
• ?Many more…

Well, I have written this blog thinking I will keep this blog post a bit easy and not load up. I will in future discuss about other performance tuning concepts. Let me know what do you think about the cartoon I made.

Reference: Pinal Dave (http://blog.sqlauthority.com)