I remember this too. Jeff Atwood made the comment in the stackoverflow blog back in 2008:
"We rely heavily on full-text search on stackoverflow.com, which worked amazingly well for us under SQL Server 2005. Looks like that’s no longer the case for SQL Server 2008, unfortunately."
See http://en.wikipedia.org/wiki/Appeal_to_fear