Joining on NULLs
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
4 reads
Bert Wagner
4 Reasons To Avoid VARCHAR(8000)
Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...
2019-04-05 (first published: 2019-03-19)
1,599 reads
4 Reasons To Avoid VARCHAR(8000)
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
4 reads
4 Reasons To Avoid VARCHAR(8000)
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
6 reads
Gaps and Islands Across Date Ranges
Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...
2019-03-12
4,974 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
23 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
1 reads
Dipping into the Cookie Jar
This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill. T-SQL Tuesday is a way for the SQL...
2019-03-29 (first published: 2019-03-12)
286 reads
Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
2 reads
Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
1 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers