Hello Dear Reader! I hope you had a fantastic weekend. This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...
2022-11-02 (first published: 2022-10-24)
139 reads
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
152 reads
Today’s coping tip is to find joy in tackling something that you have put off. I on not a bad procrastinator, but I do put plenty of things off....
2022-10-24
22 reads
This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...
2022-11-04 (first published: 2022-10-21)
125 reads
Today’s coping tip is to do something constructive to improve a difficult situation. My life is amazing, but there are certainly some difficult times. Sometimes at work, sometimes at...
2022-10-21
25 reads
I'm excited to be presenting my talk on Building a complete API in Azure
2022-10-21 (first published: 2022-10-20)
45 reads
Today’s coping tip is to avoid blaming yourself or others. Find a helpful way forward. I’ve been busy lately. My days are jammed up with a number of presentations...
2022-10-20
34 reads
First, the numbers. We registered 240 people, had about 110 on site. That’s definitely better than last year and still quite a bit under what it was pre-Covid. I’ll...
2022-11-04 (first published: 2022-10-19)
147 reads
Today’s coping tip is to take time to reflect on what you have accomplished recently. What have I done recently? Lots of stuff, but a couple things come out...
2022-10-19
21 reads
I upgraded my primary laptop to Windows 11. A few people had said they liked it, I know that I needed to keep up at some point, and in...
2022-10-19
35 reads
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers