This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a look at the content of this series - Mastering Index One of the most interesting and talked about topic in database field is Index. I am writing this Series of article to cover all the different …
Category: Index
Special Index – XML Index
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will cover following Index – XML Index Full Text Index Spatial Index Columnstore Index Prerequisites If you are reading this article, I am assuming that you know Index basics like type of Index, how it works …
Sql Server – Index Utilization Report
Index Utilization Report One day my manager came and told me that he need Index Utilization Report. He felt that during development of the project we have created so many indexes but he is not sure about how useful those are. So he wants a report which shows all the Indexes on user defined table …
Sql Server – Finding Duplicate Indexes
If you are reading this article, I assume that you have basic knowledge of Index, its types and usage. Over the years of development and chasing high performance we build and update many indexes. Due to shear number or complexity for forget to keep track of number, quantity and utilization of the indexes. For index …