title: sql server full text search on json
body: <p>i'm in need for effective representation of json in sql server so i can perform a very fast search operation. </p>
  
  <p>What i have:</p>
  
  <p>json to be stored :</p>
  
  <pre><code>{"person": {
    "name": "1234",
    "age": "99",
    "parameters": {
      "param1": "1",
      "param2": "2"
    }
  }}
  </code></pre>
  
  <p>or </p>
  
  <pre><code>{"person": {
    "name": "12345",
    "age": "996",
    "parameters": {
      "param1": "1",
      "param5": "5",
      "param7": "7"
    }
  }}
  </code></pre>
  
  <p>Parameters section can contain up to 20 of 60 different parameters.
  I need to look up for person using only some parameters. If some person has 12 i can use 0-12 parameters in search query. Name and age are always provided in search query and each person has them both.
  I have around 30m jsons in table.</p>
  
  <p>Is it possible to do it with sql server without nosql/solr/elastic?</p>