Picture this, you have a report in Power BI that someone passes off to you for data quality checks. There are a few ways to make sure your measures...
2022-08-03 (first published: 2022-07-26)
584 reads
I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed ... Continue reading
2022-08-03 (first published: 2022-07-26)
778 reads
The SQL Solutions Group asked me to do a webinar with them, which is still an honor for me. They’ve been working with various clients on DevOps development practices,...
2022-07-25
38 reads
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
103 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...
2022-07-25
30 reads
This year we’re back at our usual location on the campus of Seminole State College for SQLSaturday #1030. You may remember that last year we couldn’t use the college...
2022-08-01 (first published: 2022-07-25)
198 reads
(2022-July-25) I really liked reading printed PC Magazines (https://www.pcmag.com/) or Computerworld newspapers (https://www.computerworld.com/) when I was in school. Those magazines pictured IT System or Database Admins as a special group...
2022-08-01 (first published: 2022-07-25)
3,042 reads
Scary Scalar Functions series overview
Part One: Parallelism
Part Two: Performance
Part Three: The Cure
Foreword
In the first two parts, we have seen why the Scalar functions (UDFs) are a problem for the...
2022-07-29 (first published: 2022-07-24)
581 reads
I had a great talk today at SQL Saturday New Jersey 2022 on DevOps and databases. Good crowd and good questions. Got caught in a spotlight picture as well:...
2022-07-23
36 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...
2022-07-22
40 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