Full text search

The Comments table has been full text search enabled.  This allow fast search of information within post and replies.

There a 3 columns with a Full Text Search index:

1. title
2. body
3. json_metadata

You can use the CONTAINS or FREETEXT predicate functions to speed up queries.

Example:
Let say I want to know if anyone mentioned me in a post or comment, the following simple query will do the trick

SELECT 
   author, title, body, url 
FROM 
   Comments 
WHERE 
   author <> 'arcange'
   CONTAINS(body, 'arcange')