It’s that time of month, and I’m the host this month. I wrote the invitation last week and now its’ time to answer. I’m actually using an example from...
2022-10-21 (first published: 2022-10-11)
427 reads
Today’s coping tip is to take a small step towards a goal that matters to you. I’ve been working on a coaching certification. I don’t really need it, but...
2022-10-11
18 reads
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is ... Continue reading
2022-10-24 (first published: 2022-10-11)
331 reads
In a previous post I talked about an issue with storage failover when a Kubernetes node goes offline. In a nutshell, the issue is that the attachdetach-controller in Kubernetes...
2022-10-19 (first published: 2022-10-11)
170 reads
Everyone has heard of scaling up and scaling out compute. Have you ever heard about a term called scaling across? Before Snowflake, I never. Scaling up and down is...
2022-10-11
24 reads
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
26 reads
Today’s coping tip is to write down three things you can look forward to in the next month. Easy. Visiting my daughter. I’m heading up this weekend to watch...
2022-10-10
20 reads
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
36 reads
Hello Dear Reader!
It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.
I've had to...
2022-10-17 (first published: 2022-10-07)
168 reads
As a part of my own journey of learning within PostgreSQL, I’ve decided that I’m going to take part in PGSQL Phriday as often as I can, just as...
2022-10-21 (first published: 2022-10-07)
194 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