We have some exciting new block editor updates to share with you today including fresh collection of Portfolio block patterns, a new and improved way to embed a preview...
2021-05-17
35 reads
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 5. I’m going to do this...
2021-05-17
35 reads
At the Microsoft Business Applications Summit 2021, a ton of new features for Power BI where announced. Below is my list of top ten new features, but there were...
2021-05-17
19 reads
At the Microsoft Business Applications Summit 2021, a ton of new features for Power BI where announced. Below is my list of top ten new features, but there were...
2021-05-26 (first published: 2021-05-17)
889 reads
April 21 to 23 saw a new milestone for me. I was a new delegate for the 23rd Tech Field Day! It’s an absolute honor and thrill to be...
2021-05-17
39 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-17
25 reads
I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...
2021-05-24 (first published: 2021-05-17)
659 reads
For one reason or another data security and encryption has been coming up quite a bit in my day to day work recently and I’ve started to realise that...
2021-05-21 (first published: 2021-05-17)
457 reads
As we try to get through these strange times in the world, I am starting to see a bit more career movement in 2021 than I saw for much...
2021-05-21 (first published: 2021-05-14)
186 reads
Geeked to be speaking 2x on Saturday May 14, my second time speaking at #DataWeekender and at the very first Data Saturday Southwest 2021.
My Certification Exams Inside Out is one...
2021-05-14
19 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