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

Presentations

[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″]

microsoft

MCM Readiness Videos

Community

Gail Shaw (Blog | @SQLintheWild) – Index Posts
Kimberly Tripp (Blog | @KimberlyLTripp) – Index Posts
Michelle Ufford (twitter | Blog) – Index Posts

Books

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

15 thoughts on “Indexing Resources”

Pingback: SQL Server – Indexing Strategy – Aggregates – Stream and Hash Aggregates | Learning in the Open
Pingback: SQL Server – Delete And Table Spool | Learning in the Open
Pingback: Index-Pflege - Wie? Wann? Wie häufig? - SQL aus Hamburg - 1
Pingback: Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance? | Strate SQL
Pingback: Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance? - SQL Server - SQL Server - Toad World
Pingback: Q&A From "5 Ways to Improve Performance through Indexing" | Strate SQL
Pingback: My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server | Strate SQL
Beelze says:

April 19, 2013 at 9:56 am

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.

LikeLike

Reply
1. StrateSQL says:
  
  April 23, 2013 at 2:20 pm
  
  Thanks for the feedback. I’ll check this on the next update to the indexing script.
  
  LikeLike
  
  Reply
Pingback: A Second March 'Index Analysis' Update | Strate SQL
Pingback: That's Actually A Duplicate Index | Strate SQL
Pingback: 5 MCM Readiness Indexing Videos You Should Watch | Strate SQL
Pingback: Index Analysis Update - January 2012 | Strate SQL
Pingback: Index Analysis Post Christmas Update | Strate SQL
Pingback: Strate SQL Index Analysis: The Re-Return | Strate SQL