Searching SQL Server Tables by Keyword

Sometimes it is necessary to search a database table by keyword. In other words return all rows that have a text string similar to the required string--or the inverse, don't return any rows with the matching text string. Obviously, this can be a performance intensive task. Over at SQL Server Central, Todd Fifield posts about how to do so with better performance the obvious way--using 'LIKE'.