MOSS Search

Some Useful MOSS Search Development Related Articles
http://blogs.msdn.com/miketag/archive/2008/03/24/some-useful-moss-search-development-related-articles.aspx
What you give up with Full Text SQL Queries using Wildcard Search
http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2008/09/18/what-you-give-up-with-full-text-sql-queries-using-wildcard-search.aspx
Search: Fine Tuning search relevancy in Microsoft SharePoint Server 2007: Getting the search results your user expects
http://blogs.msdn.com/brianwilson/archive/2007/02/26/fine-tuning-search-relevancy-in-moss-2007-getting-the-search-results-your-user-expects-part-1.aspx
Using Wildcard Search Web Part to search for recently modified files
http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2008/09/17/using-wildcard-search-web-part-to-search-for-recently-modified-files.aspx
MOSS Search Word Stemming - Part 1
http://blogs.msdn.com/miketag/archive/2006/12/27/moss-search-word-stemming-part-1.aspx
MOSS Search Word Stemming - Part 2
http://blogs.msdn.com/miketag/archive/2006/12/27/moss-search-word-stemming-part-2.aspx
Best Practices: Writing SQL Syntax Queries for Relevant Results in Enterprise Search
http://msdn.microsoft.com/en-us/library/bb219479.aspx
FREETEXT Predicate in Enterprise Search SQL Syntax
http://msdn.microsoft.com/en-us/library/ms516214.aspx
Deploying and Supporting Enterprise Search
http://technet.microsoft.com/en-us/library/bb735129.aspx
CONTAINS Predicate in Enterprise Search SQL Syntax
http://msdn.microsoft.com/en-us/library/ms513993.aspx
Using Wildcards in the CONTAINS Predicate in Enterprise Search SQL Syntax
http://msdn.microsoft.com/en-us/library/ms552152.aspx

Misc
Best Practices: Using Disposable Windows SharePoint Services Objects
http://msdn.microsoft.com/en-gb/library/aa973248.aspx