Indexing Resources

When it comes to indexes, it never hurts to have a few resources on hand.  This page is collection of the indexing resources on this blog and from other places on the internet.  If you are looking for a consolidated resource on indexing, check out Expert Performance Indexing for SQL Server 2012.

Blog Posts

Index Analysis


  • [download id=”8″]
  • [download id=”78″]
  • [download id=”80″]
  • [download id=”5062″]
  • [download id=”5064″]
  • [download id=”5072″]
  • [download id=”5074″]
  • [download id=”5476″]
  • [download id=”5574″]
  • [download id=”5579″]


  1. MCM Readiness Videos
    1. Indexing Strategies
    2. Index Analysis
    3. Index Internals
    4. The Clistered Index Debate
    5. Statistics



If you have any questions or resources to add, please leave them in the comments below.

15 thoughts on “Indexing Resources

  1. Hi Jason, I found your script very usefull, and I’m using it for a couple of days, Jus found an issue while readind the index action. in your SP while insertint into #IndexStatistics the type desc has no “–” and in the update section is looking for the name with “–“. Thanks for maiking this incredible script.


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 )

Connecting to %s