Effective full-text search: go simple
Are you developing enterprise software? Then you probably faced with the problem caused by
LIKE ‘%...%'. There are some options how you can overcome on this issue even without switching to another database or database architecture once you are matured relational database like Microsoft SQL Server.