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:
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
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”
0 comments:
Post a Comment