Kristen-173977 (9/19/2015)

---

kevitra (9/18/2015)

---

With the PERSISTED index anything over 450 characters will be ignored, correct? We need 100% matching on the entire string. If a string is 700 characters most...

I do have double quotes around the CONTAINS but it is missing 1000 rows of data. I don't understand why this...

Here is what I am hearing. We always search for some text value at the beginning of the string, hence ... LIKE 'Test%' as an example. What this...

ScottPletcher (9/18/2015)

---

Since you're always searching at the start of the string, you could add a persisted computed column of ~900 bytes and search on that:

ALTER TABLE ourtable

ADD bigcolumn_search AS CAST(LEFT(bigcolumn,...