Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m always surprised to find old posts that cover current topics that I had planned to write. If they’re still useful to me, maybe they’ll be useful to you as well.
The posts for this past week in previous years are:
- Discovering Binary Pages In Sys.Indexes (24 Oct, 2012)
- Return of Index Analysis Part 5 (25 Oct, 2010)
- Lost in Translation – Deprecated System Tables – sysindexes (29 Oct, 2012)
- Lost in Translation – Deprecated System Tables – sysindexkeys (30 Oct, 2012)
Do you have something from years gone by that was posted during this week? If so, leave a comment below and we’ll give some new life to good knowledge.
Find all you need to know about indexes in one book. Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.
