Compare data of two tables
Script to facilitate the comparison of data between two SQL Server tables
2019-09-23 (first published: 2019-09-07)
4,007 reads
T-SQL
2019-08-30
777 reads
2019-08-26
1,164 reads
2019-08-23
802 reads
2019-08-19
1,128 reads
2019-08-15
754 reads
2019-08-13
1,173 reads
Dynamic SQL for beginners in 33 minutes
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
8,641 reads
2019-08-09
853 reads
Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
6,347 reads
Blogs
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers