This post took me a little longer to put together than it should have, but seeing as how I now have a two week old son at home, time is a little harder to come by these days! My T-SQL Tuesday topic ended up attracting 4 excellent responses, which I’m very happy to recap.
The first post was from Rob Farley (@rob_farley). Rob has some great insights into text search, but not full-text search. (That’s perfectly fine, I left the topic open on purpose and never intended for it to be limited to full-text search.) He tells us all about how collation can affect text searches and can greatly influence your results. Collation matters, folks! If you don’t believe me, try Rob’s example and you’ll see that he’s not joking. Rob finishes up talking about how indexes and collation can affect columns included in the GROUP BY clause, and includes a great tidbit on how collation can necessitate transformation of text when calculating hash values.
Next was Kenneth Fisher (@sqlstudent144). He walks us through the query in the header of his blog, which does a bit of text manipulation to create a hidden subtitle. I’ll admit I’ve never tried running that query myself, but the results sure are nifty. Good work, Sir!
Anders Pedersen (@arrowdrive) rolled his own full-text search back in the days before SQL Server supported it. Sounds simple and effective, and if it worked for the business, that’s all that matters, right?
Last, but certainly not least, is Jon Morisi. Jon tells us about his experiences with full-text search in terms of migration, and how recent developments in Azure sound most interesting to him. He is hopeful for the future.
So that’s T-SQL Tuesday for this month. Thanks to Rob, Kenneth, Anders, and Jon for posting, and to everyone else for reading our work. Thank you to Adam Machanic for dreaming up the idea for this a mere 76 months ago. If you’d like a complete listing of all 76 (and counting!) T-SQL Tuesday topics, Steve Jones has been kind enough to compile one.
See you next month!