Semantic Search in SQL Server 2025 – SQLServerCentral
SQL Server introduces a new data type, Vector, to support AI and machine learning workloads. This data type stores multi-dimensional data, making it useful for semantic search, similarity findings, and embedding storage. A vector stores values in an ordered numerical array. For example, a three-dimensional vector is represented as '[0,1,2]'. The Vector data type supports up to 1998 dimensions and uses a familiar JSON array format for creating and storing values
