List of articles about Index in

Thursday, June 23, 2011 |

Yesterday evening, while reading my recent Index articles, one of the fellow .NET developer asked me, “Sir, You have mentioned few things about size of index like this index is consuming big space and that index consuming low space, how can I see the size of Indexes and confirm what you have written?”

This was really a very genuine question but the answer was fairly simple T-SQL query on “SysIndexes” catalog view which I have already written but he was not aware with so finally I thought to cover up all my Indexes articles in one post so it would become good reference for some handy stuffs.

Here is the list of all articles I have written so far for the indexes:

4.)    Included column in Index

I will keep updating this page whenever I will write down something about Index.

Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of

Ask me any SQL Server related question at my “ASK Profile