List of articles about Index in SQLHub.com

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:

1.)    “Some basics about Index in SQL Server”

2.)    “Clustered Index in SQL Server”

3.)    “Non clustered Index in SQL Server ”

4.)    “Included column in Index”

5.)    “Filtered Index in SQL Server 2008/Denali”

6.)    “Cannot create index on view Msg 1940, Level 16, State 1, Line 1”

7.)    “Calculate total size of clustered and non-clustered index for database in SQL Server 2008/2005”

8.)    “Full Text Catalog and Full Text Index (Integrated Full Text Search – iFTS in SQL Server 2008 Part 2)”

9.)    “Do you know Index Statistics in SQL Server”

10.) "Index Rebuild or Reorganize in SQL Server"

11.) "Index Fillfactor in SQL Server"

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

Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of http://www.SQLHub.com

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