· 9 min read
Search in Polecat, Part 2: Vector search on a computed VECTOR column
SQL Server 2025 added a VECTOR type. Polecat 5.28 reaches it with a persisted computed column over the JSON document body, which means no write path changes and no backfill. Exact k-nearest-neighbour, three metrics that are all distances, and the one real limit.
polecat sql-server dotnet critter-stack