List of articles about Index in

Yesterday evening, while reading my recent Index articles,one of the fellow .NET developer asked me, “Sir, You have mentioned few thingsabout size of index like this index is consuming big space and that indexconsuming low space, how can I see the size of Indexes and confirm what youhave written?”
This was really a very genuine question but the answer wasfairly simple T-SQL query on “SysIndexes” catalog view which I have alreadywritten but he was not aware with so finally I thought to cover up all myIndexes articles in one post so it would become good reference for some handystuffs.
Here is the list of all articles I have written so far forthe indexes:
4.)    Includedcolumn in Index
I will keep updating this page whenever I will write downsomething about Index.
Reference: Ritesh Shah
Note: Microsoft Books online is adefault reference of all articles but examples and explanations prepared byRitesh Shah, founder of
Ask me any SQL Server related question at my “ASK Profile

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: