Performance Tuning

101 Example driven Sql Server Performance Tuning Tips and Tricks

Welcome to the’s 101 Example driven Sql Server Performance Tuning Tips and Tricks. This series of articles is suited for any Sql Server Developer/DBA who has basic Sql Server working knowledge.

I am working on Sql server from 16+ years starting from the Sql Server Version 7.0 to Sql Server 2016. Over the years I came across numerous performance issues and learnt a lot. Here with this series of 101 articles, I would like to share this experience.

What this series covers?

  • Common performance problems which every Sql Server Developer/DBA faces in his day-to-day work and solution for them
  • Clears some of the basic Performance related myths/misconceptions which most of the Developers/DBA’s have
  • Explains some of the Sql Server Performance optimization related best practices

This series of 101 articles is a work in in progress and will be adding articles periodically and update the existing articles based on the feedback from the community. Do visit us back regularly and spread a word about this performance tuning tips and tricks series to the community. If you learnt something new and like us on Facebook page Sqlhints

I would appreciate if you can share with me any of the performance problem which you came across and how you have resolved it. If it is suitable, I will share the same to the community so that everyone in the Sql community gets the benefit of your experience.

Please let me know if you have any feedback, suggestions or questions, which will be very important for the success of this series of articles.

I hope you all will enjoy this 101 Sql Server Performance Tuning Tips and Tricks series. Happy learning and best of luck!

Lists of 101 Performance tuning Tips and Tricks

Tip 1: Implicit conversion an evil for Index
Tip 2: Evils of using function on an Index Column in the WHERE clause
Tip 3: Does the order of Columns in a Composite Index matters?
Tip 4: How to find the list of all Pages that belongs to a Table and Index?
Tip 5: How to get an Index’s Root Page, Intermediate Pages and Leaf Pages Information?
Tip 6: How to Inspect the content of a DATA PAGE or INDEX PAGE ?
Tip 7: Do we need to include a Clustered Index Column too in a Non-Clustered Index to make it as a Covering Index for a Query?