The code looks like it is doing an in-memory search.
When searching an embedding space, it is quite common to look for the closest angle of the query vector against amongst the search vectors.
That is a calculation I don’t know how to make a sql server perform and given the headline I thought the article would show a neat trick for doing this.