What's new in vector indexing for Microsoft SQL | Data Exposed
Microsoft SQL Server adds updatable vector indexes with faster builds and iterative filtering
“we've made it updatable. The original index was not updatable.”
Microsoft SQL Server's vector indexing capability has received three major improvements: significantly faster index building, support for automatic background updates (inserts/updates/deletes no longer require a full rebuild), and a new iterative filtering search mode. This matters for AI practitioners building RAG systems on SQL Server, as updatable indexes lower the operational burden of keeping vector search in sync with live data.