Indexing – SQLServerCentral.com Stairway Series

SQLServerCentral.com has an excellent series on indexing. Indexing seems pretty  straightforward, improve queries performance. Blah. Blah.  In reality, they can get away from even the most seasoned DBA. The stairway series are great to learn or RE-learn SQL server specific topics. Excellent resource!

   

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key  Read more…
By David Durant 2011/03/16

Stairway to SQL Server Indexes: Level 2, Deeper into Nonclustered Indexes

By this stage, you should be familiar with the basics of SQL Server indexes. We’ve discussed what an Index actually is, as well as some of the most common types you’re likely to encounter. Now that we’ve seen some simple examples of how Indexes can be useful, we’re going to delve deeper into nonclustered indexes, as we’ll see how they can improve the performance of more complex queries.  Read more…

Stairway to SQL Server Indexes: Level 3, Clustered Indexes

Now that we’ve seen the basics of indexing, and taken a deeper dive into Nonclustered Indexes, this Level will focus on searching the table, which will, in turn, will lead us to a discussion of clustered indexes.  Read more…
By David Durant 2011/06/22

Stairway to SQL Server Indexes: Level 4, Pages and Extents

We’ve now seen how indexed and non-indexed tables perform in queries, and established “logical reads” as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more…

Stairway to SQL Server Indexes: Level 5, Included Columns

Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.  Read more…
By David Durant 2011/07/13 |

Stairway to SQL Server Indexes: Level 6, Bookmarks

A nonclustered index entry consists of search key columns, included columns, and the bookmark. The bookmark value will be either a RID or the clustered index’s key, depending upon whether the table is a heap or a clustered index. Choosing the best clustered index for a table requires that you follow three guidelines to ensure that the index key will make a good bookmark.  Read more…
By David Durant 2011/08/03 |

Stairway to SQL Server Indexes: Level 7, Filtered Indexes

A filtered index eliminates unusable entries from the index, producing an index that is as beneficial as, but much smaller than, an unfiltered index. If a certain subset of a table’s data is frequently requested, a filtered index can also be a covering index; resulting in a considerable reduction in IO.  Read more…
By David Durant 2011/08/24 |

Stairway to SQL Server Indexes: Level 8, Unique Indexes

Indexes that ensure data integrity in addition to locating rows.  Read more…
By David Durant 2011/09/14 |

Stairway to SQL Server Indexes: Level 9, Reading Query Plans

Determining how, and if, SQL Server is using your indexes.  Read more…
By David Durant 2011/10/05 |

Stairway to SQL Server Indexes: Level 10, Index Internal Structure

A detailed look the B-Tree structure – Leaf level and non-leaf level.  Read more…
By David Durant 2012/01/20

Stairway to SQL Server Indexes: Level 11, Index Fragmentation

Internal and external fragmentation – Causes, cures, and when not to care  Read more…
By David Durant 2012/02/01 |

Stairway to SQL Server Indexes: Level 12, Create Alter Drop

Options and impacts when creating, altering and dropping an index  Read more…
By David Durant 2012/02/17 |

Stairway to SQL Server Indexes: Level 13, Insert Update Delete

What happens to your indexes during normal database activity?  Read more…
By David Durant 2012/02/29 |

Stairway to SQL Server Indexes: Level 14, Index Statistics

A look at the information that helps SQL Server make better decisions.  Read more…
By David Durant 2012/03/16

Stairway to SQL Server Indexes: Level 15, Indexing Best Practices

Dos and don’ts that lead to a healthy, well-performing database.  Read more…
By David Durant 2012/03/28

 

Tiny URL for this post:
 

Share the joy

Comments are closed.