Here 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.
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:
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):
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.
Hopefully you’ve found some useful indexing information in the existing posts. And then find more in the upcoming posts.