http://www.sqlservercentral.com/blogs/stratesql/2010/09/14/an-index-on-indexing-_2300_tsql2sday/

Printed 2014/10/20 08:22PM

An Index on Indexing #TSQL2sDay

2010/09/14

old yellow eyesHere we are with another T-SQL Tuesday and time for my entry into the fray.  This month we are talking about indexes.  This is great timing because I’ve been meaning to write about indexes for a while.  A few months back I had outlined a number of articles I wanted to write and have been kind of pushing them around while working on other posts and projects.

But now I need to write a post on indexing.  Instead of actually providing some meat on indexing, I am going to provide an index on some indexing posts I wrote last year.  And then follow that up with some posts that I’ll be publishing in the next couple weeks.

SELECT Posts FROM Blog WHERE CreateDate < GETDATE()

First, let’s start with some posts I’ve already written.  A little over a year ago, I put together a few posts on analyzing your indexes.  These posts led to a query that I often use when I want to get a bearing on the state of indexes on a client’s database.  These posts were the following:

  1. Analyze Your Indexes Part 1
  2. Analyze Your Indexes Part 2
  3. Analyze Your Indexes Part 3
  4. Analyze Your Indexes Part 4
  5. Analyze Your Indexes Part 5
  6. Analyze Your Indexes Part 6
  7. Analyzing Your Indexes with a Custom Report

SELECT Posts FROM Blog WHERE CreateDate > GETDATE()

Let’s get real though, you are reading this to see what I’ve already posted.  New content is the key.  And T-SQL Tuesday is about new posts than “Yeah, I’ve done that posts”.  So here’s an index of the upcoming index posts…

The posts will be in two groups.  The first group will be on the DMV sys.dm_db_operational_stats.  This DMV is key to understanding how your database is affected by the existence of the index.  It can help answer the aged old question, “is it worth it?”

These posts will be broken out into the following topics with the publish date following them (the links will be dead for those that haven’t published yet):

  1. Index Black Ops Part 1 – Blocking (9/14/2010) (later this afternoon, of course.  I can’t totally take the summary post way out of decent content.)
  2. Index Black Ops Part 2 – Page IO Latch, Page Latch (9/15/2010)
  3. Index Black Ops Part 3 – Index Usage (9/16/2010)
  4. Index Black Ops Part 4 – Index Overhead and Maintenance (9/17/2010)
  5. Index Black Ops Part 5 – Page Splits (9/20/2010)
  6. Index Black Ops Part 6 – Fill Factor vs. Page Splits (9/21/2010)

After those are done, I’ll go back to the index analysis query that was part of the original index posts.  That information will be incorporated into the query along with some other changes.

  1. Return of Index Analysis Part 1 – sys.dm_db_index_operational_stats (9/22/2010)
  2. Return of Index Analysis Part 2 – Pro / Con Column (9/23/2010)
  3. Return of Index Analysis Part 3 – Scripting Column (9/24/2010)
  4. Return of Index Analysis Part 4 – Index Action (9/27/2010)
  5. Return of Index Analysis Part 5 – Stored procedure wrapper (9/28/2010)
  6. Return of the Index Analysis Report (9/29/2010)

Hopefully you’ve found some useful indexing information in the existing posts.  And then find more in the upcoming posts.

Related posts:

  1. Analyzing Your Indexes with a Custom Report
  2. TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
  3. Index Those Foreign Keys


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.