I have been asked to develop an efficient search engine using ASP and SQL Server. It is a keyword search, so someone chooses which city, area, type (restaurant,bar,club),type of food.. and a list of links are returned. I can think of a number of ways to do this. Can anyone point me to an article that provides the best solution (database design) for implementing such a search with ASP and SQL Server.