2026-04-01 (first published: 2026-03-27)
848 reads
2026-04-01 (first published: 2026-03-27)
848 reads
Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]
2026-03-23
10,791 reads
2026-03-23
1,088 reads
2026-03-20
1,447 reads
2026-03-18
1,244 reads
2026-03-06
588 reads
This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).
2026-03-04
2026-03-04 (first published: 2026-02-27)
793 reads
2026-02-25
1,162 reads
2026-02-20
720 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers