SQL Server 2025 Native Vectors

1. What is the new column type introduced in SQL Server 2025 for handling embeddings?

vector embedding float_array json_vector

2. Which distance metric is most commonly tuned for text models according to the lesson?

euclidean dot cosine manhattan

3. What is one of the operational advantages of using native vectors in SQL Server 2025?

Multiple security boundaries Two systems to manage Consistent updates within one transaction Separate backups for embeddings One database is easier to monitor

4. When might a dedicated vector database still be appropriate to use?

When data is small For hundreds of millions of vectors In all enterprise applications When using SQL Server 2025

Continue: Hybrid Search → Review this lesson Retake quiz