i work with computers

Archive for October, 2008

09 Oct, 2008

[Update]T-SQL Full Text Searching

Posted by: Carl In: development| sql

So I believe I found my solution: I needed to restart the full text service on the SQL box, “SQL Server Fulltext Search”.  Once I did that, I rebuilt my full text catalogs, and ran my queries (from the previous post) and all is well.  Must have been a weird caching issue, or, potentially, my [...]

08 Oct, 2008

T-SQL Full Text Searching

Posted by: Carl In: Uncategorized

So I’ve got a large SQL table of books in it, and I’ve created a full-text catalog on that table.  Before I generated the catalog, I made sure to remove all noise words from the appropriate noise words file, because I want to be able to search titles with “the” or “a” or “and” in [...]

Tags:

About

I'm an ASP.NET developer who loves learning new frameworks, and methodologies, and I absolutely love simple, yet elegant solutions (don't we all?). Since I'm constantly picking up new things, I'm always asking myself how I can use the new knowledge in my current app to make it better, or more user friendly (or even more developer friendly). In my free time I typically am coding, reading tech books or spending time with my beautiful bride. And that's about it. Hope I didn't bore you too much.