MSSQL - what kind of cache can it be?

Question

SQL Server

There is a CRM Client on Windows that works with a MSSQL 2008 database.
For some needs, an external script adds a client record to the database. So, there is a record in the database, but for some reason it does not want to be in the search through CRM.
reorganize and rebuild and even update stats ran - 0 effect.
maybe it's some other index?
DBCC FREEPROCCACHE did the same (I didn’t see how the table is indicated here), as well as among the procedures, I was looking for what could be responsible for the search - I didn’t find ...
What else can I do to make new records appear in CRM? In this case, one of the search options (when checking for duplicates by name - these records are visible).

Answer 1

Miracles, Cinderella, do not happen. You are digging in the wrong place. If the record is not found through the search in CRM, then the search does not see it (unexpectedly, but a fact), and not the curve index, not that one, etc.
What are the options? Most likely, there is a certain sign that is regularly set, but you forgot / did not take it into account when manually inserting it. Take a look at how the search is going, what's in the WHERE clause - and dig there.
Look with a profiler, so it will immediately become clear what is responsible for the search.
Yes, and at first you should be absolutely sure that there is an entry in the table, and most importantly, in the one that is being searched for.

Answer 2

абвгдеёжзийклмнопрстуфхцчшщъыьэюя преобразуется в апфкдижзийклмнапрстуфхцчшщаиуа

Это русифицированная функция SOUNDEX для поиска похожих слов и ошибок. Например: облапошил — оплапашал будут считаться одинаковыми.