Another free indexing books, more awesome!
In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server; that I co-wrote with Grant Fritchey (Blog | @gfritchey). Since these books don’t help anyone sitting on my desk, I’m giving them away over the next few weeks.
For week two, the topic is moving up a chapter to index storage fundamentals. The topic for discussion in the comments this time is…
What aspect of understanding the physical structure of indexes has proven useful in solving performance issues? Do you have a story of fragmentation? Forwarded records? Large object allocations? Ever used DBCC or page allocations to directly solve a performance issue?
If you have a story to share in this area, leave it in a comment below. At the end of a week, I’ll select one of the comments and send that author a copy of the book.
June, 17 Update
The winner for the book this week is Todd Kleinhans. He talked about using DBCC PAGE to recover missing data from a database. Something that takes a lot of patience and time, but works when you need the data.
The other comments was by SQLDBAPro, who talked about how he’s used the structure of the non-clustered index to better understand how to build indexes.