It’s time for week 5 of giving out some copies of Expert Performance Indexing for SQL Server. So far, I’ve sent out four copies of the book based on comments from those posts. You can find the previous weeks’ posts to review those topics here: 1, 2, 3, and 4.
Expert Performance Indexing for SQL Server is a book I co-wrote with Grant Fritchey (Blog | @gfritchey) last summer, which I think can be a valuable resource to anyone building indexes on SQL Server. As part of finishing the book, Apress sent me a number of copies of the book to share with people. I figured the best way to share these out is to give them away to people that comment on this blog.
So here’s a topic for leaving a comment this week…
For week five, the question will focus on chapters six and seven, which cover full-text indexing and indexes on memory-optimized tables, respectively. The topic for discussion in the comments this time is…
What challenges have you solve with full-text indexes? Or what have you learned about indexes on memory optimized tables?
If you have a story to share in this area, leave it in a comment below. After a week, I’ll select one of the comments and send that author a copy of the book.
July 25 Update
A bit late on selecting the winner for this post, but after looking over the comments, the winner for the book this week is Margaret Norkett. She upgraded from SQL Server 2005 to 2012 with the “old style” full-text indexes and ran into issues with the migration creating large numbers of ndf files. Just for the pain of dealing with that many ndf files, she deserves the book.
Learn more about full-text indexes in chapter six of Expert Performance Indexing for SQL Server.
The other comments this week were from:
- Robert built a resume search capabilities for HR using full-text indexes.
- Peter used full-text indexing back in the day prior to the recent improvement. While it was combersome at that time and required some workarounds, today he’d jump right in with it.